Re: Ability to listen on two unix sockets - Mailing list pgsql-hackers

From Honza Horak
Subject Re: Ability to listen on two unix sockets
Date
Msg-id 4FD0CD08.6090003@redhat.com
Whole thread Raw
In response to Re: Ability to listen on two unix sockets  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Ability to listen on two unix sockets  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 06/06/2012 04:50 PM, Andres Freund wrote:
> On Wednesday, June 06, 2012 04:38:42 PM Tom Lane wrote:
>> You might think we should design this exactly like the TCP-socket
>> multiple-listen-addresses case, ie just have a config variable
>> containing a list of directory names.  The sticking point there is
>> that the directories aren't really interchangeable.  In particular,
>> there is still going to be one directory that is the one hard-wired
>> into libpq.
> I wonder if the whole issue doesn't require libpq to also try multiple
> hardcoded socket locations.

I guess so. Let's say we add additional socket support and some server 
uses one e.g. at /var/run/postgresql. Then a client can either (1) 
specify the same path explicitly and then we don't need to specify any 
additional sockets on the client side or (2) stick to the default path, 
which is hard-coded, currently to /tmp.

Going back to the original problem (inaccessible /tmp directory), it is 
the case (2) -- a client uses the default path. So any additional 
client-side socket option won't probably help here, but we would 
probably need a second hard-coded path e.g. at /var/run/postgresql.

Regards,
Honza



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: XLog changes for 9.3
Next
From: Tom Lane
Date:
Subject: Re: Avoiding adjacent checkpoint records