December 5th, 2009, 11:25 AM
FATAL: no pg_hba.conf entry for host “::1”
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
December 5th, 2009, 01:10 PM
December 5th, 2009, 01:17 PM
Should i repost it there or wait for a mod to move it, i did actually look but missed that there was a postgresql section, sorry
December 6th, 2009, 05:08 AM
That line is commented, so it is not active.
Originally Posted by morny
Remove the # at the beginning...