Re: pg_hba.conf, md5 and .pgpass - Mailing list pgsql-novice

From Tom Lane
Subject Re: pg_hba.conf, md5 and .pgpass
Date
Msg-id 29714.1170739085@sss.pgh.pa.us
Whole thread Raw
In response to pg_hba.conf, md5 and .pgpass  ("Mick McElarney" <Mick.McElarney@maxsp.com>)
List pgsql-novice
"Mick McElarney" <Mick.McElarney@maxsp.com> writes:
> What should I change so that it reads my /home/postgres/.pgpass file
> when I execute a psql -Upostgres databasename?

When you're logged in as somebody besides postgres, you mean?  It can't
do that, and it'd be a huge security hole if it could.

You can, however, have it read your *own* .pgpass file for an entry
giving the postgres password.

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Composed Key and autoincrement
Next
From: "Ashish Karalkar"
Date:
Subject: Re: Stored Procedure to return a result set