To BackupGo Start->Run, 'cmd' OK.
At the command prompt type:
- Code: Select all
cd "C:\Program Files\PostgreSQL\8.3\bin"
Note: C:\Program Files is the typical PostgreSQL installation directory but may be different on your computer. Change accordingly.
Then type:
- Code: Select all
pg_dumpall > pt3_database.out
Enter your database user password and your backup database will be dumped to the file named 'pt3_database.out'.
To RestoreGo Start->Run, 'cmd' OK.
At the command prompt type:
- Code: Select all
cd "C:\Program Files\PostgreSQL\8.3\bin"
Then type:
- Code: Select all
psql -f pt3_database.out postgres
Note: 'postgres' is your database user account name
Best regards,
Derek