Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue

Hi Tom,

/fnal/ups/prd/postgres/v9_5_3_x64/Linux-2-6/lib/libpq.so.5  is actually symlink but it points to library that came from
rpminstall. 

ls -ltr /fnal/ups/prd/postgres/v9_5_3_x64/Linux-2-6/lib/libpq.so*

-rwxr-xr-x 1 postgres postgres 193296 May 14 17:36 /fnal/ups/prd/postgres/v9_5_3_x64/Linux-2-6/lib/libpq.so.5.8
lrwxrwxrwx 1 postgres postgres     12 Aug 11 11:39 /fnal/ups/prd/postgres/v9_5_3_x64/Linux-2-6/lib/libpq.so.5 ->
libpq.so.5.8

Well, I like the idea of adding /var/run/postgresql to unix_socket_directories. However, I would like to see this
change-in-behaviour-in-9.5document. 

If you agree with me, documented or not, that will still leave some inconsistency where psql default is /var/run
(assumingit is documented) and server default is /tmp (this is already documented in unix_socket_directories and it
worksas it says. The socket is created in /tmp by default) 

Thanks,
Murthy


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Saturday, August 13, 2016 11:12 AM
To: Murthy Nunna <mnunna@fnal.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres v9.5.3 and v9.5.4 Unix Socket Issue

Murthy Nunna <mnunna@fnal.gov> writes:
> Following is output from "ldd" command:
> ldd /fnal/ups/prd/postgres/v9_5_3_x64/Linux-2-6/bin/psql | grep -i libpq
>         libpq.so.5 =>
> /fnal/ups/prd/postgres/v9_5_3_x64/Linux-2-6/lib/libpq.so.5
> (0x00007fbce99f5000)

And that actually is the copy of psql you're invoking?

Another theory worth considering is that something is helpfully setting PGHOST=/var/run/postgresql in psql's
environment.

            regards, tom lane