Re: strange behavior of pg_hba.conf file

On Wed, Nov 22, 2023 at 11:22 AM Atul Kumar <akumar14871(at)gmail(dot)com> 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.
>
>
I think you changed something else, at the same time.

> 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.
>

A definition for host "::1", user "postgres", database "postgres". It's
right there in the error message.