Search Postgresql Archives

Re: strange behavior of pg_hba.conf file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Nov 22, 2023 at 11:22 AM Atul Kumar <akumar14871@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux