Re: pg_dump shell script with ~/.pgpass

On Thu, Jan 27, 2005 at 08:47:40AM -0800, MargaretGillon@chromalloy.com wrote:

> I need to create a shell script for cron.daily to run that will do pg_dump
> for my database. I am using Redhat 9 and Postgresql v7.3.4.  Currently when
> I run the dump manually the command I use is
>
> #pg_dump -u -C -D -f /tmp/owl.sql owl
>
> What should the command look like using ~/.pgpass ?

The same.  The file is automatically used if found and has the right
permissions.

> My other question... Is cron.daily is being run by root? If so would I need
> to put the .pgpass file in root's home directory?

Don't use root to do the backup, use postgres.  crontab -e -u postgres

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"El día que dejes de cambiar dejarás de vivir"