From: "Capobianco, Tony" <Tony.Capobianco@bcbsma.com>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: issues connecting to RDS from psql 9.2 v 14.2
Thread-Topic: issues connecting to RDS from psql 9.2 v 14.2
Thread-Index: AdhaUEIdPGwjGMmxRt2j4twTB2m6bg==
Date: Wed, 27 Apr 2022 16:13:34 +0000
Message-ID: 
 <BLAPR13MB4660C0AB068F8EF1F7A0AE479EFA9@BLAPR13MB4660.namprd13.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?nboIvoCqVlbDMmnWgHnDKmlS56Um5hw96yAEYzeXccJ6pVJEvmYSXEQ/hUVo?=
 =?us-ascii?Q?PWeTpqwlnyMlHJxedrLI0PZKKAQ8Tm8gb7qbxVbmi7/YdOQzBh6IhkW0uvbB?=
 =?us-ascii?Q?QxN3356NqXyc/7aqwTaUn978QqsnDmYVT3CqBUEDDEJ0vlfJNfEXYtsSWHoP?=
 =?us-ascii?Q?yFy72eH6modnjbAwFln/ZNDFP5HAgt8/KO1OA4RWe5xeNwUm8x70Xk2tBLn2?=
 =?us-ascii?Q?8q8YOogbetOvPRUAirN6gdV3HxvYFxyV41DgzY3GYJXRJOuQcukZbwRQq2z9?=
 =?us-ascii?Q?7DHNmUK7Sq+mx+Cq3fhO8hf+CyH4v7I3oGoasTNcYVPZTS44Y2IzZRrdy532?=
 =?us-ascii?Q?3d9/wS/G2aFKIUsI01cdVVzQZipV8jy1eL/c1suSNQ77KkIQftuPDauSfEjv?=
 =?us-ascii?Q?+gSdeIwdjBlUabwWY7Ch8KlZjflH9/TdY6moHOdOFIQwNDRR/mb+fJpvJeVP?=
 =?us-ascii?Q?1fK2EL4vYZ+ZFo/nykZBP2l3M9jpYSg5/OFesx6q+qAdoEE7js4TvvatnDR5?=
 =?us-ascii?Q?7QCNzjajotDpb8U2PrDI2UiuvOVbDsA4qqRJ7qE73H/MHmbs5E20QcHNQzxW?=
 =?us-ascii?Q?fGD2kVDC9QRiZgYX1MZMwJ1Osekb5JNRaK6hV4gVlecip6IfAIIjb4KLOiBP?=
 =?us-ascii?Q?hINsjKCwtuKOmesdi5ZKoLygm+m3zEUqj98yT/eixY35fnSIuxva3nl09GFx?=
 =?us-ascii?Q?KD8DM8ObTZpbSw1c1frVpCckTaCxEb5CsieBU0Wsp8971Pfjccmz45nTfEnK?=
 =?us-ascii?Q?nis27LXRaOc2kbGmICTa6bYh9uWE2z40wv1KfzZbm02EAVDfMyfsZqASje3C?=
 =?us-ascii?Q?LxaAsJSJ4yuDUEOloZBTxf8KofKSHzVHVkNXh7VHlIdqOVkFlG0HmDijaZEE?=
 =?us-ascii?Q?kz8lSJS1dShTXMB0vHqCifBMtc31kJNMOCphQH8CPwWcYbqUNlv9q2XFMtZw?=
 =?us-ascii?Q?aqXrTuoikCSFlVedu+Mk3C5aCev+kzQfQq5tS/BvK66fCVMd/5GIJqnjVot8?=
 =?us-ascii?Q?EE2XlciJ+ppZlPpHmgFeFC/8vpxLD6FTdcgwMLBOM+2K4ykOvwvShmO9Bwa5?=
 =?us-ascii?Q?AFyPASjQxXlfAEKATsVc96YYVm4iom1qKXu7Wic0sv+bvj655pOV7L5zPESQ?=
 =?us-ascii?Q?owFg2FDzXWAqB5g7Zy3vCt+Ksc3VA7mSLPs/fAJA9W97wOa4vlKMlO+T0k4c?=
 =?us-ascii?Q?AoQSvtYZmmkI2+vhvnQFrDk7FeU7xCe4veWLeWLXUOEDidsAIykU0CKjY1/O?=
 =?us-ascii?Q?YzpxiyqQbSGF4pp7bX/MMMu6Tg3XOSygukmUYhkX/q1DEPtEzrXvYrz6TPh5?=
 =?us-ascii?Q?kC4Nzq/J+JxQPwAScKn72M2yboqboqOfCxI4nrY/ZTNwvn5djEYjKvBLbNeM?=
 =?us-ascii?Q?Rk1uuXzi1MGqjjzZzmD5IX2NgkVZDAhOC+wk1qmxrtaVZrSJye6MxVPBhgeu?=
 =?us-ascii?Q?pBwLNAPUKFgi9aPKMWJliN/3TP0ZoI8wPy1d0oKe3QF8z9RoTE18EJD8Np1g?=
 =?us-ascii?Q?DMor5/7gQChirsVIkediacSFC5bgLmnVI0qul5ypvpQfu5zYNNvY4ShFgZNI?=
 =?us-ascii?Q?gYWvHZbz1NtsYJPFRgJBnO3b+e4m8zkiSm80WWdvMDCJAOr1J5NMwcCWi5dk?=
 =?us-ascii?Q?nMZk5hU+qaqpnn2IlrQq4ulYZhI09yPVlVbKK5c5QeKBSYjcok0zFVg03EXf?=
 =?us-ascii?Q?VCXhWDKe/9WiyREWUYKiVMK+cHlM2kG5oJxK/Kc6m7sLzKessqBF3pU5gqks?=
 =?us-ascii?Q?xFaoQM4LRA=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_BLAPR13MB4660C0AB068F8EF1F7A0AE479EFA9BLAPR13MB4660namp_"
MIME-Version: 1.0
X-OriginatorOrg: BCBSma.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: BLAPR13MB4660.namprd13.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 19489017-a385-479d-754c-08da2868e144
X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Apr 2022 16:13:34.7103
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 7f6a7d1e-1213-434b-981c-95c72d65f665
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 Et/19CMO8f4JYCSCfc7VZ3Oxbn8ci6SMQ4K7bPDF9z8DrLw4F38zxNDxUIwQJHPcJrfbnIXY8nUWUupEtvF5TA==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: MW2PR13MB4234
X-VPM-MSG-ID: c11efcfb-6393-424f-b2ff-81fafeb03fc3
X-VPM-HOST: vmvpm02.z132.zixworks.com
Cc: 
X-VPM-GROUP-ID: 6cc5da64-1bbc-46d6-9864-e5fd82e520ff
X-VPM-ENC-REGIME: Plaintext
X-VPM-IS-HYBRID: 0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/BLAPR13MB4660C0AB068F8EF1F7A0AE479EFA9%40BLAPR13MB4660.namprd13.prod.outlook.com>
Precedence: bulk

--_000_BLAPR13MB4660C0AB068F8EF1F7A0AE479EFA9BLAPR13MB4660namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 obse=
rve 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/postg=
resql-14.2/pg14.2/usr/local/pgsql/lib
[postgres@ servername ~]$ /u01/apps/postgres/postgresql-14.2/pg14.2/usr/loc=
al/pgsql/bin/psql -h RDS-instance.rds.amazonaws.com -p 5432 -d dbname -U ro=
ot
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.1=
1.12.13", user "root", database "dbname", SSL off
[postgres@ servername ~]$

Any ideas of why I'm encountering this issue?

Thanks.

Tony

--_000_BLAPR13MB4660C0AB068F8EF1F7A0AE479EFA9BLAPR13MB4660namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Our RHEL 7.9 installation comes with PostgreSQL 9.2 =
installed which I know has been desupported.&nbsp; We installed 14.2 in a n=
on-default location and observe this unusual behavior:<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">[postgres@servername ~]$ psql -h RDS-instance.rds.am=
azonaws.com -p 5432 -d dbname -U root<o:p></o:p></p>
<p class=3D"MsoNormal">Password for user root:<o:p></o:p></p>
<p class=3D"MsoNormal">psql (9.2.24, server 12.8)<o:p></o:p></p>
<p class=3D"MsoNormal">WARNING: psql version 9.2, server version 12.0.<o:p>=
</o:p></p>
<p class=3D"MsoNormal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Som=
e psql features might not work.<o:p></o:p></p>
<p class=3D"MsoNormal">SSL connection (cipher: cipher text here, bits: 256)=
<o:p></o:p></p>
<p class=3D"MsoNormal">Type &quot;help&quot; for help.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">daldb=3D&gt; \q<o:p></o:p></p>
<p class=3D"MsoNormal">[postgres@ servername ~]$ export LD_LIBRARY_PATH=3D/=
u01/apps/postgres/postgresql-14.2/pg14.2/usr/local/pgsql/lib<o:p></o:p></p>
<p class=3D"MsoNormal">[postgres@ servername ~]$ /u01/apps/postgres/postgre=
sql-14.2/pg14.2/usr/local/pgsql/bin/psql -h RDS-instance.rds.amazonaws.com =
-p 5432 -d dbname -U root
<o:p></o:p></p>
<p class=3D"MsoNormal">psql: error: connection to server at &quot; RDS-inst=
ance.rds.amazonaws.com &quot; (10.33.131.184), port 5432 failed: FATAL:&nbs=
p; no pg_hba.conf entry for host &quot;10.11.12.13&quot;, user &quot;root&q=
uot;, database &quot;dbname&quot;, SSL off<o:p></o:p></p>
<p class=3D"MsoNormal">[postgres@ servername ~]$<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Any ideas of why I&#8217;m encountering this issue?<=
o:p></o:p></p>
<p class=3D"MsoNormal"><br>
Thanks.<o:p></o:p></p>
<p class=3D"MsoNormal"><br>
Tony<o:p></o:p></p>
</div>
</body>
</html>

--_000_BLAPR13MB4660C0AB068F8EF1F7A0AE479EFA9BLAPR13MB4660namp_--