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 rpm install. 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.5 document. If you agree with me, documented or not, that will still leave some inconsistency where psql default is /var/run (assuming it is documented) and server default is /tmp (this is already documented in unix_socket_directories and it works as it says. The socket is created in /tmp by default) Thanks, Murthy -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Saturday, August 13, 2016 11:12 AM To: Murthy Nunna <mnunna@xxxxxxxx> Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue Murthy Nunna <mnunna@xxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
