The entries that I changed were to replace the md5 with scram-sha-256 and remove unnecessary remote IPs.
But it has nothing to do with connecting the server locally with "psql -d postgres -U postgres -h localhost"
But when I try to connect it locally I get this error. So it is related to local connections only and when I pass the hostname or ip of the server it works fine without any issue.
Regards.
On Wed, Nov 22, 2023 at 10:31 PM Atul Kumar <akumar14871@xxxxxxxxx> wrote:
The entries that I changed were to replace the md5 with scram-sha-256 and remove unnecessary remote IPs.But it has nothing to do with connecting the server locally with "psql -d postgres -U postgres -h localhost"But when I try to connect it locally I get this error. So it is related to local connections only and when I pass the hostname or ip of the server it works fine without any issue.Regards.On Wed, Nov 22, 2023 at 9:55 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:On Wed, Nov 22, 2023 at 11:22 AM Atul Kumar <akumar14871@xxxxxxxxx> wrote:Hi,I have postgres 12 running in centos 7, recently I changed the authentication of entries of pg_hba.conf to scram-sh-256 for localhost.I think you changed something else, at the same time.Since then I have started getting the below error:no pg_hba.conf entry for host "::1", user "postgres", database "postgres
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
What I am missing here, please suggest.
A definition for host "::1", user "postgres", database "postgres". It's right there in the error message.
