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