Re: Help automate pg_dump

Hello, Evan,

We use RedHat 7.2

Do an su to (or login as) postgres and create a cron job that runs your backup script. When cron runs the job it assumes the postgres user ID and runs the job, hence no username or password needed. Note, it maybe necessary to re-establish posgtres' rights locally if they have been modified from the original install.

Good luck.

======= At 2002-06-18, 02:01:00 you wrote: =======

>We just upgraded from 7.1.3 to 7.2.1 and are at a loss on how to
>script the pg_dump routine. We use this tool for backup, but can not
>get around the requirement for username/password to be interactive.
>
>We require login from the localhost, and can not revert to trusted
>connections.
>
>If the username/password must be interactive, how can I script backup
>of the server?
>
>Evan,

Best regards.
William Meloney
bmeloney(at)mindspring(dot)com
2002-06-18