Provisioning Manager: PostgreSQL dump location

Answered Question
May 13th, 2009

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.

I have this problem too.
0 votes
Correct Answer by ldardon about 7 years 6 months ago

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
ldardon Tue, 05/19/2009 - 13:13

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.

Actions

This Discussion