Re: strange behavior of pg_hba.conf file

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: strange behavior of pg_hba.conf file
Дата
Msg-id d6fc59f5-1fdf-49e5-ae9f-da959fd1802f@aklaver.com
обсуждение исходный текст
Ответ на Re: strange behavior of pg_hba.conf file  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: strange behavior of pg_hba.conf file
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore enhancements