FATAL: no pg_hba.conf entry for host “::1”

morny's Avatar, Join Date: Dec 2009
Newbie Member
Hi,

Im using an application that connects to postgreSQL, now its being tested on a few machines and connects fine but on 1 machine i get this FATAL: no pg_hba.conf entry for host “::1”, user “postgres”, database “myDatabase", SSL off.

Heres the HBACONFIG FILE DETAILS
# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5

So the issue seems to be with the last line on IPv6, to be honest i dont even know what IPv6 is, could disabling IPv6 do the trick or do i need to add something?

The funny thing is with the exact same details a different application connects to postgreSQL fine? Any ideas and bare in mind im a newbie when explaining
stephen186's Avatar, Join Date: Feb 2009
Go4Expert Member
I would suggest you to search http://www.postgresql.org for this error. There are lots of such errors described there.