TCP/IP with 7.4 beta2 broken? - Mailing list pgsql-hackers

From Tommi Mäkitalo
Subject TCP/IP with 7.4 beta2 broken?
Date
Msg-id 200309012156.05874.t.maekitalo@epgmbh.de
Whole thread Raw
Responses Re: TCP/IP with 7.4 beta2 broken?
Re: TCP/IP with 7.4 beta2 broken?
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: ohp@pyrenet.fr
Date:
Subject: Re: Index creation takes for ever
Next
From: Tom Lane
Date:
Subject: Re: Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...)