From: | Tommi Mäkitalo <t(dot)maekitalo(at)epgmbh(dot)de> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | TCP/IP with 7.4 beta2 broken? |
Date: | 2003-09-01 19:59:17 |
Message-ID: | 200309012156.05874.t.maekitalo@epgmbh.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-01 20:01:16 | Re: Unixware Patch (Was: Re: Beta2 Tag'd and Bundled ...) |
Previous Message | ohp | 2003-09-01 19:59:11 | Re: Index creation takes for ever |