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 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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Saturday, August 13, 2016 11:12 AM
To: Murthy Nunna <mnunna(at)fnal(dot)gov>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Postgres v9.5.3 and v9.5.4 Unix Socket Issue

Murthy Nunna <mnunna(at)fnal(dot)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