Re: PostgreSQL backup script - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL backup script
Date
Msg-id 16231.1051798936@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL backup script  (Søren Neigaard <s.neigaard@mobilethink.dk>)
List pgsql-general
=?iso-8859-1?Q?S=F8ren_Neigaard?= <s.neigaard@mobilethink.dk> writes:
> I need this to work without passwords

Then don't use a password-based authentication mechanism.
If you are on an OS that supports IDENT over Unix-socket connections,
that's often a pretty good alternative for verifying local connections.

If you are on PG 7.3 you could also consider keeping passwords in
~/.pgpass.

            regards, tom lane


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: RECORD fields by name
Next
From: "Peter Darley"
Date:
Subject: Re: Problem with || and data types