SR slaves and .pgpass - Mailing list pgsql-hackers

From Andrew Dunstan
Subject SR slaves and .pgpass
Date
Msg-id 4C0C083C.3030607@dunslane.net
Whole thread Raw
Responses Re: SR slaves and .pgpass  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
The docs state, w.r.t. $subject:
   The password can be provided either in the primary_conninfo string   or in a separate ~/.pgpass file on the standby
server.

I tried this with a database name of "replication" in the .pgpass file, 
which matches what we need to use in pg_hba.conf, but it failed 
miserably, and only worked when I used a wildcard for the database name 
in the .pgpass file.

If this is expected it needs to be documented more clearly; if not, it's 
a bug.

I expect this to be quite  a common thing to do - many people will be 
like me and dislike putting passwords in config files.

cheers

andrerw


pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Out of date docs: DISABLE/ENABLE TRIGGER
Next
From: Robert Haas
Date:
Subject: Re: [PATCH] Fix leaky VIEWs for RLS