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