Re: automate backup and restore

Posted by Darshangera on Jan 12, 2011; 5:30am
URL: http://ngl.70.s1.nabble.com/automate-backup-and-restore-tp5868821p5913493.html

Dear sir,
Thanks for info. But still I am not able to integrate password information. On doc link, -w option is for no password is mentioned. But when we use pg_dump with -w no, it says -w option not supported.
2nd thing is pgpass.conf file for hostname:port:database:username:password. But this file is not present anywhere.
Can you help me in writing batch file to take automated backup.

Thanks