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

[morny]

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

[Andy Shellam (Mailing Lists)-2]

Hi,

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?

Your machine is connecting to PostgreSQL using IPv6's "localhost" address.  IPv6 is a newer format of IP addressing that allows for more IP addresses - ::1 = 127.0.0.1, basically.

Newer TCP/IP stacks attempt to connect to localhost using the IPv6 address first, instead of IPv4 (the current format.)

When you connect, try passing "-h 127.0.0.1" to psql or whatever app/library you're using.  That should force it to connect over IPv4.  Or just uncomment the IPv6 line in your pg_hba.conf and restart PostgreSQL.

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

Is the different application on a different server?  If so, it could be that the other app's OS is using IPv4 by default instead of IPv6.  Or the app is connecting over an IPv4 address (e.g. 127.0.0.1) instead of "localhost."

Regards,

Andy

[Tom Lane-2]

morny <[hidden email]> writes:
> # 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,

Yup: it's commented out.  Get rid of the '#'.

                        regards, tom lane

--
Sent via pgsql-general mailing list ([hidden email])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[saleem]

Go to the server where you are trying to connect, open the file "pg_hba.conf" and add the IP of the machine that you are using to connect to ..

i hope this post helps