Re: [PATCHES] .pgpass file and unix domain sockets

hackers - any opinions?

The biggest downside would be that a pgpass file would be version 
specific for this feature. The badness of this is somewhat mitigated by 
the ability we now have to specify an alternative pgpassfile location.

cheers

andrew

-------- Original Message --------
Subject:     Re: [PATCHES] .pgpass file and unix domain sockets
Date:     Tue, 16 May 2006 12:16:53 -0400
From:     Tom Lane <tgl@sss.pgh.pa.us>
To:     Andrew Dunstan <andrew@dunslane.net>
CC:     Joachim Wieland <joe@mcknight.de>, pgsql-patches@postgresql.org
References:     <20060516122554.GA4009@mcknight.de> 
<11676.1147787022@sss.pgh.pa.us> <4469F499.1040002@dunslane.net> 
<13302.1147795016@sss.pgh.pa.us> <4469FA5A.3090504@dunslane.net>



Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> Personally I wouldn't object to making it match "localhost" in all
>> cases.  That's what the documentation says, and the use-case for
>> doing something more complicated seems pretty thin.

> I almost agree. If anything, I'd prefer to provide for an explicit entry 
> covering all Unix Domain sockets - it took me by some surprise to find a 
> while back that "localhost" covers that case - it seems a mismatch with 
> how pg_hba.conf works.

Well, that'd break existing .pgpass files (unless we match localhost
too, which seems to defeat the purpose).  But maybe it's worth doing
for consistency's sake.  I think we should bring it up on a more
widely read list than -patches if you want to propose a
non-backwards-compatible change ...