Re: Scripting a pg_dumpall/pg_dump backup using bash or perl - Mailing list pgsql-novice

From Tom Lane
Subject Re: Scripting a pg_dumpall/pg_dump backup using bash or perl
Date
Msg-id 15800.1107441554@sss.pgh.pa.us
Whole thread Raw
In response to Scripting a pg_dumpall/pg_dump backup using bash or perl  ("Gavin Henry" <ghenry@suretecsystems.com>)
List pgsql-novice
"Gavin Henry" <ghenry@suretecsystems.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

pgsql-novice by date:

Previous
From: Kretschmer Andreas
Date:
Subject: Re: Scripting a pg_dumpall/pg_dump backup using bash or perl
Next
From: "Schuhmacher, Bret"
Date:
Subject: Can't change LC_CTYPE/locale