Re: Scripting a pg_dumpall/pg_dump backup using bash or perl

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gavin Henry" <ghenry(at)suretecsystems(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Scripting a pg_dumpall/pg_dump backup using bash or perl
Date: 2005-02-03 14:39:14
Message-ID: 15800.1107441554@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Gavin Henry" <ghenry(at)suretecsystems(dot)com> writes:
> 1. How can I script the above so passwords aren't asked for?

The cleanest solution is to put the password in a ~/.pgpass file so the
script doesn't need to know it at all. Or you can think about using
non-password-based auth methods, such as IDENT.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Schuhmacher, Bret 2005-02-03 15:28:37 Can't change LC_CTYPE/locale
Previous Message Kretschmer Andreas 2005-02-03 10:14:00 Re: Scripting a pg_dumpall/pg_dump backup using bash or perl