Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1njkp5-00060b-2v for pgsql-admin@arkaria.postgresql.org; Wed, 27 Apr 2022 16:47:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1njkp3-0000rW-VF for pgsql-admin@arkaria.postgresql.org; Wed, 27 Apr 2022 16:47:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1njkp3-0000rN-L6 for pgsql-admin@lists.postgresql.org; Wed, 27 Apr 2022 16:47:25 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1njkp1-0008Rj-62 for pgsql-admin@lists.postgresql.org; Wed, 27 Apr 2022 16:47:25 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 23RGlHMe395141; Wed, 27 Apr 2022 12:47:17 -0400 From: Tom Lane To: "Capobianco, Tony" cc: "pgsql-admin@lists.postgresql.org" Subject: Re: issues connecting to RDS from psql 9.2 v 14.2 In-reply-to: References: Comments: In-reply-to "Capobianco, Tony" message dated "Wed, 27 Apr 2022 16:13:34 -0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <395139.1651078037.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Wed, 27 Apr 2022 12:47:17 -0400 Message-ID: <395140.1651078037@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk "Capobianco, Tony" writes: > Our RHEL 7.9 installation comes with PostgreSQL 9.2 installed which I kn= ow has been desupported. We installed 14.2 in a non-default location and = observe this unusual behavior: > [postgres@servername ~]$ psql -h RDS-instance.rds.amazonaws.com -p 5432 = -d dbname -U root > Password for user root: > psql (9.2.24, server 12.8) > WARNING: psql version 9.2, server version 12.0. > Some psql features might not work. > SSL connection (cipher: cipher text here, bits: 256) > Type "help" for help. > daldb=3D> \q > [postgres@ servername ~]$ export LD_LIBRARY_PATH=3D/u01/apps/postgres/po= stgresql-14.2/pg14.2/usr/local/pgsql/lib > [postgres@ servername ~]$ /u01/apps/postgres/postgresql-14.2/pg14.2/usr/= local/pgsql/bin/psql -h RDS-instance.rds.amazonaws.com -p 5432 -d dbname -= U root > psql: error: connection to server at " RDS-instance.rds.amazonaws.com " = (10.33.131.184), port 5432 failed: FATAL: no pg_hba.conf entry for host "= 10.11.12.13", user "root", database "dbname", SSL off > [postgres@ servername ~]$ > Any ideas of why I'm encountering this issue? Looks like you neglected to build psql with OpenSSL support, and the server is insisting on having an SSL connection. regards, tom lane