Postgres Pro
Downloads
Home   >   mailing lists

Re: strange behavior of pg_hba.conf file - Mailing list pgsql-general

From Ron Johnson
Subject Re: strange behavior of pg_hba.conf file
Date
Msg-id CANzqJaBkoU6SBeVvN3=VtFLgDLP1wTm7a_v9W6KYOr990sHRtg@mail.gmail.com
Whole thread Raw
In response to strange behavior of pg_hba.conf file  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general
Tree view
On Wed, Nov 22, 2023 at 11:22 AM Atul Kumar <akumar14871@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.

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: strange behavior of pg_hba.conf file
Next
From: Adrian Klaver
Date:
Subject: Re: strange behavior of pg_hba.conf file