Re: strange behavior of pg_hba.conf file

On 11/22/23 08:21, Atul Kumar wrote:
> 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 host is ::1 which IPv6 and your pg_hba.conf entry below is for IPv4.
You need to add IPv6 line.

>
>
>
>
> 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 <http://127.0.0.1/32> scram-sha-256
>
>
>
> What I am missing here, please suggest.
>
>
>
>
> Regards,
>
> Atul
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com