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
Attachment:
signature.asc
Description: This is a digitally signed message part
