From: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
---|---|
To: | Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> |
Cc: | Phillip Smith <phillip(dot)smith(at)weatherbeeta(dot)com(dot)au>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: trouble with pg_dumpall |
Date: | 2008-02-28 02:31:33 |
Message-ID: | Pine.LNX.4.64.0802271830250.14059@discord.home.frostconsultingllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
From | Date | Subject | |
---|---|---|---|
Next Message | Phillip Smith | 2008-02-28 02:32:00 | Re: Backup to Tape Incomplete |
Previous Message | Tena Sakai | 2008-02-28 02:26:54 | Re: trouble with pg_dumpall |