issues connecting to RDS from psql 9.2 v 14.2

From: "Capobianco, Tony" <Tony(dot)Capobianco(at)bcbsma(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: issues connecting to RDS from psql 9.2 v 14.2
Date: 2022-04-27 16:13:34
Message-ID: BLAPR13MB4660C0AB068F8EF1F7A0AE479EFA9@BLAPR13MB4660.namprd13.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Our RHEL 7.9 installation comes with PostgreSQL 9.2 installed which I know has been desupported. We installed 14.2 in a non-default location and observe this unusual behavior:

[postgres(at)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=> \q
[postgres@ servername ~]$ export LD_LIBRARY_PATH=/u01/apps/postgres/postgresql-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?

Thanks.

Tony

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2022-04-27 16:47:17 Re: issues connecting to RDS from psql 9.2 v 14.2
Previous Message Nikhil Shetty 2022-04-27 15:36:44 Re: Postgres Stale Statistics