Hi,

I tried 7.4 beta2 and had difficulties setting up TCP/IP with it. It complains 
about mising pg_hba.conf-entry.

After installing and initdb I edited my postgres.conf to enable tcpip 
(tcpip_socket = true) and added a pg_hba.conf-entry like this:

local   all         all                                             trust
host    all         all         192.168.41.0      255.255.255.0     trust
host    all         all         127.0.0.1         255.255.255.255   trust

192.168.41.0/255.255.255.0 is the net we use.
Next I started postmaster and tried to connect via TCP/IP. From the same host 
I set PGHOST to 127.0.0.1 and PGUSER to postgres and tried a psql -l. I got:

psql: FATAL:  no pg_hba.conf entry for host "::ffff:127.0.0.1", user 
"postgres", database "template1"

It looks like postgres tries some IPv6-adresses and failes.

Same with 7.3.4 works just fine.

Tommi Mäkitalo

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to