Hemil Ruparel <hemilruparel2002@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