I'm in the process of migrating from an RDS pg14 instance to pg15.3. As part of the migration process, the application code makes a test connection to the new instance. This failed. I tried manually connecting to the kube pod where the test query was submitted from, and from there was able to manually connect to the new instance (using psql) just fine.
:
2023-06-04 00:29:11.890 UTC,,,2764,"
10.120.80.80:46914",647bdad7.acc,1,"",2023-06-04 00:29:11 UTC,,0,LOG,00000,"connection received: host=10.120.80.80 port=46914",,,,,,,,,"","not initialized",,0
2023-06-04 00:29:11.891 UTC,"b2bc_owner","b2bcreditonline",2764,"
10.120.80.80:46914",647bdad7.acc,2,"authentication",2023-06-04 00:29:11 UTC,7/1009,0,FATAL,28000,"no pg_hba.conf entry for host ""10.120.80.80"", user ""b2bc_owner"", database ""b2bcreditonline"", no encryption",,,,,,,,,"","client backend",,0
:
2023-06-04 00:43:56.114 UTC,,,4046,"
10.120.80.80:56356",647bde4c.fce,1,"",2023-06-04 00:43:56 UTC,,0,LOG,00000,"connection received: host=10.120.80.80 port=56356",,,,,,,,,"","not initialized",,0
2023-06-04 00:43:56.127 UTC,"b2bc_owner","b2bcreditonline",4046,"
10.120.80.80:56356",647bde4c.fce,2,"authentication",2023-06-04 00:43:56 UTC,7/1626,0,LOG,00000,"connection authenticated: identity=""b2bc_owner"" method=md5 (/rdsdbdata/config/pg_hba.conf:15)",,,,,,,,,"","client backend",,0
2023-06-04 00:43:56.127 UTC,"b2bc_owner","b2bcreditonline",4046,"
10.120.80.80:56356",647bde4c.fce,3,"authentication",2023-06-04 00:43:56 UTC,7/1626,0,LOG,00000,"connection authorized: user=b2bc_owner database=b2bcreditonline application_name=psql SSL enabled (protocol=TLSv1.2, cipher=ECDHE-RSA-AES256-GCM-SHA384, bits=256)",,,,,,,,,"","client backend",,0
2023-06-04 00:43:58.814 UTC,"b2bc_owner","b2bcreditonline",4046,"
10.120.80.80:56356",647bde4c.fce,4,"idle",2023-06-04 00:43:56 UTC,7/1627,0,LOG,00000,"statement: select 0 as dummy;",,,,,,,,,"psql","client backend",,0
2023-06-04 00:43:58.814 UTC,"b2bc_owner","b2bcreditonline",4046,"
10.120.80.80:56356",647bde4c.fce,5,"SELECT",2023-06-04 00:43:56 UTC,7/0,0,LOG,00000,"duration: 0.341 ms",,,,,,,,,"psql","client backend",,1147616880456321454
2023-06-04 00:44:04.402 UTC,"b2bc_owner","b2bcreditonline",4046,"
10.120.80.80:56356",647bde4c.fce,6,"idle",2023-06-04 00:43:56 UTC,,0,LOG,00000,"disconnection: session time: 0:00:08.287 user=b2bc_owner database=b2bcreditonline host=10.120.80.80 port=56356",,,,,,,,,"psql","client backend",,0
:
In case it's relevant, the application code is running on nodejs v18.14.2 using pg 8.11.0.