strange behavior of pg_hba.conf file

Поиск
Список
Период
Сортировка
От Atul Kumar
Тема strange behavior of pg_hba.conf file
Дата
Msg-id CA+ONtZ7nMGfC23Gpgq7x9YtuP3YpqwXDQZNK6NdLTFn7e2fhrw@mail.gmail.com
обсуждение исходный текст
Ответы Re: strange behavior of pg_hba.conf file
Re: strange behavior of pg_hba.conf file
Re: strange behavior of pg_hba.conf file
Список pgsql-general
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 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.




Regards,

Atul

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Feature request: pg_get_tabledef(text)
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: General support on postgres replication