On Thu, 27 Jan 2005, Richard Huxton wrote:
[EMAIL PROTECTED] wrote:
[snip]
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/ow
On Thu, Jan 27, 2005 at 08:47:40 -0800,
[EMAIL PROTECTED] wrote:
>
> What should the command look like using ~/.pgpass ?
You might also consider using using ident as the authentication method if
it is supported by your os.
---(end of broadcast)--
[EMAIL PROTECTED] wrote:
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?
This is probably the right list - your message may have been missed
though, there can be a lot of traffic.
I need to create a shell script for cron
On Thu, Jan 27, 2005 at 08:47:40AM -0800, [EMAIL PROTECTED] 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 /tm
On Thursday 27 January 2005 11:47 am, [EMAIL PROTECTED] saith:
>
> 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 don't know about .pgpass, so I can't help you with that. Root does run
cron.daily. You can se
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 Ma
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 q