issues connecting to RDS from psql 9.2 v 14.2

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Capobianco, Tony <[email protected]>
To: [email protected] <[email protected]>
Subject: issues connecting to RDS from psql 9.2 v 14.2
Date: Wed, 27 Apr 2022 16:13:34 +0000
Message-ID: <BLAPR13MB4660C0AB068F8EF1F7A0AE479EFA9@BLAPR13MB4660.namprd13.prod.outlook.com> (raw)

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@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

view thread (5+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: issues connecting to RDS from psql 9.2 v 14.2
  In-Reply-To: <BLAPR13MB4660C0AB068F8EF1F7A0AE479EFA9@BLAPR13MB4660.namprd13.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox