Re: strange behavior of pg_hba.conf file

The error message is EXPLICIT, and DOES NOT LIE. Either someone removed
the ::1 entry, or you're now using IPv6.

On Wed, Nov 22, 2023 at 12:03 PM Atul Kumar <akumar14871(at)gmail(dot)com> wrote:

> The entries that I changed were to replace the md5 with scram-sha-256 and
> remove unnecessary remote IPs.
>
> But it has nothing to do with connecting the server locally with "psql -d
> postgres -U postgres -h localhost"
>
> But when I try to connect it locally I get this error. So it is related to
> local connections only and when I pass the hostname or ip of the server it
> works fine without any issue.
>
>
>>>>
>>>> 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.
>>>
>>