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