Thanks for the clarification. According to this page, https://jdbc.postgresql.org/documentation/changelog.html#version_42.2.0, scram support was added in JDBC driver 42.2.0. I am on 42.2.18. And using the java code mentioned above, I still get the same error.
On Fri, Nov 27, 2020 at 9:06 PM Tom Lane <t...@sss.pgh.pa.us> wrote: > Hemil Ruparel <hemilruparel2...@gmail.com> writes: > > When I try to connect to the database, the log says: > >> FATAL: password authentication failed for user "user" > >> DETAIL: Connection matched pg_hba.conf line 88: "host user > > password 0.0.0.0/0 scram-sha-256" > > > So I think the client is using scram-sha-256 > > No, what that says is that the server is going to insist on scram-sha-256. > If the client can't handle SCRAM, then a failure would be expected. > > regards, tom lane >
