From: | MargaretGillon(at)chromalloy(dot)com |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump shell script with ~/.pgpass |
Date: | 2005-01-15 20:14:10 |
Message-ID: | OFF2A804D2.217FAC99-ON88256F8A.006DBF82-88256F8A.006E848B@CHROMALLOY.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2005-01-15 20:23:31 | Re: OID Usage |
Previous Message | Tom Lane | 2005-01-15 20:08:20 | Re: Pgsql taking a *lot* of CPU time (unkillable). |