Recently, a few PostgreSQL users reported that they got connection failures after switching to PostgreSQL 14. Why do I get the error FATAL:  password authentication failed for a user in the new server? has become one of the most intriguing questions. At least in one case, it was a bit of a surprise that the [&]

https://www.percona.com/blog/postgresql-14-and-recent-scram-authentication-changes-should-i-migrate-to-scram/