Provisioning Manager: PostgreSQL dump location

[csawest.dc]

Hi All,

I tried to do a database backup on PM 1.2 by going to Start > All Programs > PostgreSQL8.2 > Command Prompt and typing in the command as mentioned in the user guide as "pg_dumpall -o -U<username> >[path and fileForBackup] "

I could not understand the format for path/file, tried

pg_dumpall -o -U postgres >D:\BACKUP_PM > did not work

pg_dumpall -o -U postgres > worked but I do not know where is the backup dumped.

Anybody has clue, please let me know.

[ldardon · Accepted solution]

You have to specify a file name for the command to work.

Here is the command:

pg_dumpall -o -U postgres > D:\Backup\.bk

Also, this command will ask for password 3 to 4 times.

[csawest.dc]

Thank you, buddy! It worked.