Skip site navigation (1) Skip section navigation (2)

Re: trouble with pg_dumpall

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: (view raw or whole 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/ "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:

Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC
Phone: 650-780-7908	FAX: 650-649-1954

In response to


pgsql-admin by date

Next:From: Phillip SmithDate: 2008-02-28 02:32:00
Subject: Re: Backup to Tape Incomplete
Previous:From: Tena SakaiDate: 2008-02-28 02:26:54
Subject: Re: trouble with pg_dumpall

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group