From: | Atul Kumar <akumar14871(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | IPV6 issue |
Date: | 2023-11-23 19:18:25 |
Message-ID: | CA+ONtZ62uKURz1SLZqhJ1pwwFJB0BRXzPRN1zdAX3xo0Vo-JFQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
Then I tested the same issue in my second machine
getent hosts localhost
::1 localhost localhost.localdomain localhost6
localhost6.localdomain6
but in my second machine I didn't face any such issue while using command
"psql postgres", I was able to login into the database without such error.
The pg_hba.conf on both machines are identical without having any IPV6
entry in it.
The entry of pg_hba.conf is like below:
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all
scram-sha-256
# IPv4 local connections:
host all postgres 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 ?
Please help.
Regards.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2023-11-23 19:32:13 | Re: Odd Shortcut behaviour in PG14 |
Previous Message | David G. Johnston | 2023-11-23 18:40:38 | Re: Odd Shortcut behaviour in PG14 |