Hi all, 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.
Here are the (hopefully) relevant chunks from the database log: : 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. Any thoughts? Thanks, Steve
