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. Regards. On Wed, Nov 22, 2023 at 10:31 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. > > > Regards. > > > On Wed, Nov 22, 2023 at 9:55 PM Ron Johnson <ronljohnso...@gmail.com> > wrote: > >> On Wed, Nov 22, 2023 at 11:22 AM Atul Kumar <akumar14...@gmail.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. >> >
