Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bYb6a-0007ij-SO for pgsql-admin@arkaria.postgresql.org; Sat, 13 Aug 2016 15:44:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bYb6a-0005hj-FC for pgsql-admin@arkaria.postgresql.org; Sat, 13 Aug 2016 15:44:12 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bYb4u-0003oi-3p for pgsql-admin@postgresql.org; Sat, 13 Aug 2016 15:42:28 +0000 Received: from ns5.gunduz.org ([107.170.136.15] helo=ns1.gunduz.org) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bYb4n-0006GW-4I for pgsql-admin@postgresql.org; Sat, 13 Aug 2016 15:42:26 +0000 Received: from asus-laptop-03-gunduz-org (unknown [88.248.122.226]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by ns1.gunduz.org (Postfix) with ESMTPSA id DF2403FD15; Sat, 13 Aug 2016 15:42:18 +0000 (UTC) Message-ID: <1471102924.7580.4.camel@gunduz.org> Subject: Re: Postgres v9.5.3 and v9.5.4 Unix Socket Issue From: Devrim =?ISO-8859-1?Q?G=FCnd=FCz?= To: Murthy Nunna , "pgsql-admin@postgresql.org" Date: Sat, 13 Aug 2016 18:42:04 +0300 In-Reply-To: References: Content-Type: multipart/signed; micalg="pgp-sha256"; protocol="application/pgp-signature"; boundary="=-19zRV3msKP98lBNC6HxL" X-Mailer: Evolution 3.20.5 (3.20.5-1.fc24) Mime-Version: 1.0 X-Pg-Spam-Score: -2.3 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --=-19zRV3msKP98lBNC6HxL Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, On Sat, 2016-08-13 at 13:29 +0000, Murthy Nunna wrote: >=20 > I am having an issue with version 9.5. I am unable to connect locally wit= h > psql using port syntax. This worked in earlier versions (for sure in 9.3)= . >=20 > 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 > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Is the server running locally = and accepting > =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 connections on Unix domain soc= ket > "/var/run/postgresql/.s.PGSQL.5434"? I think you are using 9.3's psql to connect to 9.5 instance. That won't wor= k for the RPMs (unless you specify -h option as stated in the thread). We cha= nged the default socket directory from /tmp to /var/run/postgresql. Please use 9= .5's psql. Regards, --=20 Devrim G=C3=9CND=C3=9CZ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR --=-19zRV3msKP98lBNC6HxL Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part Content-Transfer-Encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAABCAAGBQJXrz/MAAoJENjDPf6Sz261XxcP/j9QF3C8WHozm6PdtGM29MIM 7QND3uPMhzQZ1V9J9IpXoyNy/vatm5tzzIYuFRaMMNZTjeewMaZD+cKArK6U86Cw lvFzlTlTBEjqjaCnOrR5tFSz5xizyTAGFnF3hfIF1lXFw+EjQYSzpw3Dbdtmqx0C 8irBOL2Nu+Tex9UJ7WmN34O+jeCxceV2Mld9yUsFdeCeWogPaiVOs4QdqBoyRR01 zL+X7lbEX861JeR4KRCGmVbIrT12LsJV3m55QpUmjn1rBTSpDd61oGjT5cv8gQmv C5Eh3WMGi9xoVUGjHlJwaprwse6fOqpMn+FG3FJMjY5PMfgvZnq3iOJpHb6JWMkP VpfiWJjxjhqcyyBEcg7ats17EqYAlrTx0UN0vdxnyp3gcLrlmdC02mwiQ2TacvRb 6nBEl+TS1z339NU8UAmAe7wTEl40g2sIUpydmpUTcM9FryYAMqxGGoCELKHbpdQP aCPC3vNyw2CT1Rp8XQKMzEupi7UR+AFFrhGIAyEsOoUVGTK5DuRWKPJztXn3q8oh RPlohB1ksr1Fl6zVzUmUmOZUE3xaT7nygW6d+Dt/0L7/T5Jw5xy5pQvEkReEObBw AS+gU1VQmNBKqwrg1paCm1hzR1n3/unDFvqPUz31L5MTI5kw+9nmpZ4SxcJeo4JF ZuXPtRX8bfvnyLdCw7wW =CyQh -----END PGP SIGNATURE----- --=-19zRV3msKP98lBNC6HxL--