Notes about PostgreSQL: Difference between revisions

From OpenPetra Wiki
Jump to navigation Jump to search
Line 12: Line 12:
   CREATE USER tom WITH PASSWORD 'myPassword';
   CREATE USER tom WITH PASSWORD 'myPassword';


  nant createSQLStatements
  You might to set the environment variables before creating the database:
set PGUSER=postgres
set PGPASSWORD=myPassword
 
  nant recreateDatabase
  nant recreateDatabase
  nant resetDatabase
  nant resetDatabase

Revision as of 09:27, 28 August 2009

installation

Windows

  • don't install as a service
initdb
"postgres" -D "petra"
psql 
 CREATE USER tom WITH PASSWORD 'myPassword';
You might to set the environment variables before creating the database:
set PGUSER=postgres
set PGPASSWORD=myPassword
nant recreateDatabase
nant resetDatabase

Some notes

  • drop database but tables are still there when creating the database again: [1]; reason: tables are in template1 db, and that is used as a template for creating the new database
  • drop all tables in db: DROP SCHEMA public CASCADE; [2]
    • you should create a new schema public again (especially if this is the template1 db): CREATE SCHEMA public;