Postgres v9.5.3 and v9.5.4 Unix Socket Issue

From: Murthy Nunna <mnunna(at)fnal(dot)gov>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Postgres v9.5.3 and v9.5.4 Unix Socket Issue
Date: 2016-08-13 13:29:36
Message-ID: CY1PR09MB109934F368C846AA07D29AC9B8100@CY1PR09MB1099.namprd09.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Robert Burgholzer 2016-08-13 13:47:01 Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue
Previous Message Venkata B Nagothi 2016-08-13 00:24:03 Re: Multiple Tablespaces with single mount point?