Re: strange behavior of pg_hba.conf file
| От | Ron Johnson |
|---|---|
| Тема | Re: strange behavior of pg_hba.conf file |
| Дата | |
| Msg-id | CANzqJaBkoU6SBeVvN3=VtFLgDLP1wTm7a_v9W6KYOr990sHRtg@mail.gmail.com обсуждение исходный текст |
| Ответ на | strange behavior of pg_hba.conf file (Atul Kumar <akumar14871@gmail.com>) |
| Список | pgsql-general |
On Wed, Nov 22, 2023 at 11:22 AM Atul Kumar <akumar14871@gmail.com> 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.
В списке pgsql-general по дате отправления: