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@aklaver.com