Re: trouble with pg_dumpall

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@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954