Postgres Pro
Downloads
Home   >   mailing lists

Re: How to debug authentication issues in Postgres - Mailing list pgsql-general

From Tom Lane
Subject Re: How to debug authentication issues in Postgres
Date
Msg-id 704984.1606491414@sss.pgh.pa.us
Whole thread Raw
In response to Re: How to debug authentication issues in Postgres  (Hemil Ruparel <hemilruparel2002@gmail.com>)
Responses Re: How to debug authentication issues in Postgres  (Hemil Ruparel <hemilruparel2002@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Gustavsson Mikael
Date:
Subject: SV: Problem with pg_notify / listen
Next
From: Hemil Ruparel
Date:
Subject: Re: How to debug authentication issues in Postgres