From: | Murthy Nunna <mnunna(at)fnal(dot)gov> |
---|---|
To: | Devrim Gündüz <devrim(at)gunduz(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue |
Date: | 2016-08-13 15:54:07 |
Message-ID: | CY1PR09MB1099F45CFEBC5D5C056695C5B8100@CY1PR09MB1099.namprd09.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)gunduz(dot)org]
Sent: Saturday, August 13, 2016 10:42 AM
To: Murthy Nunna <mnunna(at)fnal(dot)gov>; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] 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
From | Date | Subject | |
---|---|---|---|
Next Message | Murthy Nunna | 2016-08-13 16:00:35 | Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue |
Previous Message | Devrim Gündüz | 2016-08-13 15:42:04 | Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue |