Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: How to debug authentication issues in Postgres
Date
Msg-id b9022916-0cb2-44ff-27c5-0402c293b7b5@aklaver.com
Whole thread Raw
In response to Re: How to debug authentication issues in Postgres  (Hemil Ruparel <hemilruparel2002@gmail.com>)
List pgsql-general
Tree view 
On 11/28/20 6:08 AM, Hemil Ruparel wrote:
> I commented out scram-sha-256 lines for IPv4 and IPv6. I still got 
> authentication failure. The log output now says:
> FATAL:  password authentication failed for user "centos"
> DETAIL:  Connection matched pg_hba.conf line 89: "host       database    
> user 0.0.0.0/0 <http://0.0.0.0/0>               md5"
> 

You have to remember we have no idea of how you are trying to make the 
connection. So where does this failure occur, with all connection 
methods, just DataGrip, some other method?

-- 
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Hemil Ruparel
Date:
Subject: Re: How to debug authentication issues in Postgres
Next
From: Adrian Klaver
Date:
Subject: Re: How to debug authentication issues in Postgres