On 11/23/23 11:18, Atul Kumar wrote:
I have postgres 12 running in centos 7 on my two machines, recently I
changed the authentication of entries of pg_hba.conf to
scram-sha-256 for localhost.
Since then in my one machine, I have started getting the below error
when I use command "psql postgres"
no pg_hba.conf entry for host "::1", user "postgres", database "postgres
I found that localhost is resolve to IPV6 by using below command:
getent hosts localhost
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
I don't think this is telling you the whole story.
See what is in
/etc/hosts
and in
/etc/nsswitch.conf
on each machine.
host all postgres 127.0.0.1/32
<http://127.0.0.1/32> scram-sha-256
I am not able to understand that my both machines are resolved to IPV6
then why is my first machine is throwing this error ?
Change this 127.0.0.1/32 to localhost and then be covered for both
situations.
Please help.
Regards.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
