Re: yum packages for 9.5 vs <=9.4

On 01/21/2016 12:00 PM, John R Pierce wrote:
> On 1/21/2016 11:46 AM, Devrim GÜNDÜZ wrote:
>> Hi,
>>
>> On Thu, 2016-01-21 at 10:09 -0800, John R Pierce wrote:
>>> >the yum packages for 9.5 apparently changed the path of the socket
>>> >from /tmp to /var/run/postgresql
>> I think we use both now. If not, that must be a packaging bug. On my
>> boxes, I can see that the unix_socket_directory points to both.
>>
>
>
> indeed, 9.5 is putting it in both places, but 9.5's libpq is looking for
> it in /var/run/pgsql ... the problem is the older versions are only
> putting it in /tmp, so the newer libpq doesn't work.

Alternate method:

http://www.postgresql.org/docs/9.5/static/libpq-pgservice.html

If you are following what I assume is the pattern of 'naked' binaries
being the most recent version, you could create a service file for that
version that overrides the defaults. That being said using one version
of a binary to connect to multiple Postgres versions seems fragile.

>
> does unix_socket_directory allow dual locations in 9.1+ ? I guess I
> should just try that...
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com