Notes about PostgreSQL

From OpenPetra Wiki

Revision as of 20:55, 30 May 2009 by Pokorra (talk | contribs) (1 revision)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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

Retrieved from ‘https://wiki.openpetra.org/index.php?title=Notes_about_PostgreSQL&oldid=60’