Provisioning Manager: PostgreSQL dump location

Answered Question
May 13th, 2009
User Badges:

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.

Correct Answer by ldardon about 8 years 1 month 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
User Badges:

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