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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
