On Thu, Jan 27, 2005 at 08:47:40AM -0800, MargaretGillon@xxxxxxxxxxxxxx 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" ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
