Backup Database Probs

[chadsdavis]

How do I backup my Database in PTO?
I have clicked on PostgreSQL Database Functions and backup it then asks me for a backup/file name? Do I just make one up and a folder to put it into?

Also when I get past this step it asks for the name of a "dump" file? No matter what I type (I don't know where this should go anyway) it doesn't accept it as an allowable name.


Can someone please give me some step by step (Like i am a 10 year old) instructions on what to do?

Thanks
Chad

[ptrack mike]

I have clicked on PostgreSQL Database Functions and backup it then asks me for a backup/file name? Do I just make one up and a folder to put it into?

Yes.

Also when I get past this step it asks for the name of a "dump" file?

I've never heard of this. What version of PostgreSQL are you using?

[chadsdavis]

8.3
asks for location of 'pg_dump.exe'

[ptrack pat]

The file should be in the c:\program files\postgresql\8.3\bin folder. If you navigate to that folder you should be able to select the pg_dump.exe file.

[chadsdavis]

Ok...
That got me through that part but now a dos screen is coming up wanting a password...It won't let me type anything in.
Then I noticed that in the blue letters on the pto program it says if this happens change the config file, edit pg_hba.conf....
I scrolled to the bottom and changed the md5 to trust....
But it still asks for a password in a dos prompt when it happens....
Will restart and try again...
Any advice would be appreciate...remember I am using vista and 8.3


Thanks
Chad

[chadsdavis]

Actually now I am pretty confused...
On one hand the PTO screen says to change the above posted config if a dos window asked for a password.....
On the other hand on the pop up screen that comes up when you select the backup initiate process says DON"T CLOSE DOS WINDOW!!!!

So which one is it because I have change the config to TRUST and the password dos window still comes up?

Thanks
Chad

[ptrack mike]

Make the change that it instructs you to do and then try again.

[chadsdavis]

Made change to "trust"...dos prompt still asks for password.

[ptrack mike]

Try removing the password as it describes here:
viewtopic.php?f=45&t=4510