strange behavior of pg_hba.conf file - Mailing list pgsql-general

From Atul Kumar
Subject strange behavior of pg_hba.conf file
Date
Msg-id CA+ONtZ7nMGfC23Gpgq7x9YtuP3YpqwXDQZNK6NdLTFn7e2fhrw@mail.gmail.com
Whole thread Raw
Responses Re: strange behavior of pg_hba.conf file
Re: strange behavior of pg_hba.conf file
Re: strange behavior of pg_hba.conf file
List pgsql-general
Hi,

I have postgres 12 running in centos 7, recently I changed the authentication of entries of pg_hba.conf to scram-sh-256 for localhost.

Since then I have started getting the below error:

no pg_hba.conf entry for host "::1", user "postgres", database "postgres




The entry of pg_hba.conf is like below:

# TYPE  DATABASE        USER            ADDRESS                 METHOD

 

# "local" is for Unix domain socket connections only

local   all           all                                          scram-sha-256

# IPv4 local connections:

host    all           postgres     127.0.0.1/32               scram-sha-256



What I am missing here, please suggest.




Regards,

Atul

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Feature request: pg_get_tabledef(text)
Next
From: Ron Johnson
Date:
Subject: Re: General support on postgres replication