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

Hi All,

 

I am having an issue with version 9.5. I am unable to connect locally with psql using port syntax. This worked in earlier versions (for sure in 9.3).

 

We downloaded and installed postgres from rpm(s). The installation is on Linux-x64.

We did pg_upgrade of an existing 9.5.3 cluster.

psql -U postgres -d template1 -p 5434

psql: could not connect to server: No such file or directory

        Is the server running locally and accepting

        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5434"?

 The socket is in /tmp and that is where it is supposed to be.

srwxrwxrwx   1 postgres postgres       0 Aug 13 08:16 .s.PGSQL.5434

-rw-------   1 postgres postgres      49 Aug 13 08:16 .s.PGSQL.5434.lock

 

Following line is from postgresql.conf:

unix_socket_directories = ‘/tmp’

Do you know why the new build (9.5.3 psql and 9.5.4 as well) is looking in /var/run/postgresql? This seems to be some inconsistency in new build. BTW, I can connect successfully to this 9.5 database using 9.3 psql executable.

Thanks for reading my post.

Murthy Nunna

Database Services Group

Enterprise Server Operations Dept.

Fermi National Accelerator Laboratory