- set PGHOME=C:\Program Files\PostgreSQL\8.3
- set PGDATA=%PGHOME%\data
- set PGLIB=%PGHOME%\lib
- set PGHOST=localhost
- set PATH=%PGHOME%\bin;%PATH%
- dropdb -U postgres stoneu
- createdb -U postgres -T template0 stoneu
- pg_restore -U postgres -d stoneu .\database\postgresql8.3.backup
|
