Re: IPV6 issue

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(dot)klaver(at)aklaver(dot)com