On Wed, 27 Feb 2008, Tena Sakai wrote:
I have turned every stone over and I am pretty close to convince myself that the way I am doing doesn't work. I can't believe I am the one to discover such a bug. I would love to hear somebody prove me wrong. But in the meantime, maybe I will take a bit different approach. Namely: Is there anyway I can pass the password to pg_dumpall via crontab? Maybe via argv? Then I would be able to say via crontab entry: xx xx * * * bash /usr/local/pgsql/cronbase/moo.sh "password!" Of course, what I am stating above doesn't work. I am asking if you have any suggestion in a similar fashion. I am all ears.
Just use the .pgpass file. Here's the documentation page for 8.2: http://www.postgresql.org/docs/8.2/static/libpq-pgpass.html -- Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
