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.
