Hi Devrim, I am using 9.5 psql to connect to 9.5 instance which is not working. You said "We changed the default socket directory from /tmp to /var/run/postgresql". Could you point this to me in documentation please? Thanks, Murthy -----Original Message---- From: Devrim Gündüz [mailto:devrim@xxxxxxxxxx] Sent: Saturday, August 13, 2016 10:42 AM To: Murthy Nunna <mnunna@xxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue Hi, On Sat, 2016-08-13 at 13:29 +0000, Murthy Nunna wrote: > > 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"? I think you are using 9.3's psql to connect to 9.5 instance. That won't work for the RPMs (unless you specify -h option as stated in the thread). We changed the default socket directory from /tmp to /var/run/postgresql. Please use 9.5's psql. Regards, -- Devrim GÜNDÜZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
