Re: [GENERAL] pg_dump shell script with ~/.pgpass

2005-01-27 Thread Frank Miles
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

Re: [GENERAL] pg_dump shell script with ~/.pgpass

2005-01-27 Thread Bruno Wolff III
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)--

Re: [GENERAL] pg_dump shell script with ~/.pgpass

2005-01-27 Thread Richard Huxton
[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

Re: [GENERAL] pg_dump shell script with ~/.pgpass

2005-01-27 Thread Alvaro Herrera
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

Re: [GENERAL] pg_dump shell script with ~/.pgpass

2005-01-27 Thread Terry Lee Tucker
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

Re: [GENERAL] pg_dump shell script with ~/.pgpass

2005-01-27 Thread MargaretGillon
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

[GENERAL] pg_dump shell script with ~/.pgpass

2005-01-15 Thread MargaretGillon
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