Re: pg_hba.conf change in 7.4

Seum-Lim Gan wrote:
> Hi Bruce,
>
> I tried to newly compiled 7.4 with HAVE_IPV6 commented out
> in /src/include/pg_config.h.
>
> After that I tried psql:
>
> psql -U scncraft -h localhost
> psql: FATAL: no pg_hba.conf entry for host "::1", user "scncraft",
> database "A"
>
> This happens the same way whether I have this line in pg_hba.conf or not:
> # IPv6-style local connections:
> host all all ::1
> ffff:ffff:ffff:ffff:ffff:ffff:
> ffff:ffff ident pspmap

Forget ident at this point. Let's see if we can get your machine to use
the IPv4 line in pg_hba.conf.

Try this --- compile with IPv6 commented out, as you have done, then
remove the ::1 line from pg_hba.conf, and see if you can connect using
this:

> psql -U scncraft -h 127.0.0.1

and see what happens. Is your 'localhost' mapped to an IPv4 OR IPv6
address? Also, I am sure you realized you can connect without -h just
using unix domain sockets, but that will not allow you to use ident.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073