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

From Adrian Klaver
Subject Re: strange behavior of pg_hba.conf file
Date
Msg-id d6fc59f5-1fdf-49e5-ae9f-da959fd1802f@aklaver.com
Whole thread Raw
In response to Re: strange behavior of pg_hba.conf file  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general


On 11/22/23 10:01 AM, Adrian Klaver wrote:


On 11/22/23 9:55 AM, Andreas Kretschmer wrote:


Am 22.11.23 um 18:44 schrieb Atul Kumar:
I am giving this command
psql -d postgres -U postgres -p 5432 -h localhost
Then only I get that error.

so localhost resolved to an IPv6 - address ...


Yeah, you should take a look at:

/etc/hosts


In meantime include a  line for IPv6 in pg_hba.conf. where the address would be:

::1/128 

Or you could change


host all postgres 127.0.0.1/32 scram-sha-256


to


host all postgres localhost scram-sha-256



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: strange behavior of pg_hba.conf file
Next
From: Tom Lane
Date:
Subject: Re: pg_restore enhancements