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 <akumar14...@gmail.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. >>> >>
