| 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: | Whole Thread | Raw Message | 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 |