Notes about PostgreSQL

installation

Windows

• see http://www.postgresql.org/download/windows for current version
• eg. http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.3.7/win32/postgresql-8.3.7-1.zip

• see also http://jacqueschirag.wordpress.com/2007/08/15/installing-postgresql-on-windows-vista/

• don't install as a service

initdb
"postgres" -D "petra"
psql 
 CREATE USER tom WITH PASSWORD 'myPassword';

nant createSQLStatements
nant recreateDatabase
nant resetDatabase