I posted the message below on 1/15/05 and haven't received a reply yet.
Should I be asking this question on a different list?
Thank you.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297
----- Forwarded by Margaret Gillon/CLA/Chromalloy on 01/27/2005 08:38 AM
-----
Margaret
Gillon/CLA/Chroma
lloy To
pgsql-general@postgresql.org
01/15/2005 12:14 cc
PM
Subject
pg_dump shell script with ~/.pgpass
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 ?
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?
I only have two postgresql users right now, myself and postgres. On the
redhat server I have only two users, myself and root, there is no user
postgres.
TIA.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297