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.
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.