Re: strange behavior of pg_hba.conf file

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: strange behavior of pg_hba.conf file
Дата
Msg-id 947a953a-e2ab-497e-9381-6abaf0796560@aklaver.com
обсуждение исходный текст
Ответ на strange behavior of pg_hba.conf file  (Atul Kumar <akumar14871@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On 11/22/23 08:21, Atul Kumar 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.
> 
> Since then I have started getting the below error:
> 
> no pg_hba.conf entry for host "::1", user "postgres", database "postgres

The host is ::1 which IPv6 and your pg_hba.conf entry below is for IPv4. 
You need to add IPv6 line.

> 
> 
> 
> 
> 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 <http://127.0.0.1/32> scram-sha-256
> 
> 
> 
> What I am missing here, please suggest.
> 
> 
> 
> 
> Regards,
> 
> Atul
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

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