From: Devrim Gündüz <devrim@gunduz.org>
To: Murthy Nunna <mnunna@fnal.gov>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue
Date: Sat, 13 Aug 2016 18:42:04 +0300
Message-ID: <1471102924.7580.4.camel@gunduz.org> (raw)
In-Reply-To: <CY1PR09MB109934F368C846AA07D29AC9B8100@CY1PR09MB1099.namprd09.prod.outlook.com>
References: <CY1PR09MB109934F368C846AA07D29AC9B8100@CY1PR09MB1099.namprd09.prod.outlook.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
Attachments:
signature.asc (application/pgp-signature, 818B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: devrim@gunduz.org, mnunna@fnal.gov
Subject: Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue
In-Reply-To: <1471102924.7580.4.camel@gunduz.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox