Re: IPV6 issue - Mailing list pgsql-general

From Adrian Klaver
Subject Re: IPV6 issue
Date
Msg-id efaad723-8d08-4640-a5d2-d8b91f20cb39@aklaver.com
Whole thread Raw
In response to IPV6 issue  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Odd Shortcut behaviour in PG14
Next
From: Adrian Klaver
Date:
Subject: Re: Inquiry Regarding Initial Seed for pgsql Protocol Fuzz Testing