Re: Cannot reach pg server using -h localhost - Mailing list pgsql-general

> and if you have it listen to 127.0.0.1, you see 127.0.0.1 in netstat?

Yes, netstat reflects exactly what I have in listen_addresses:

listen_addresses = '127.0.0.1, ::1'

~ netstat -an | grep 5432
tcp6       0      0  ::1.5432                    *.*                    LISTEN
tcp4       0      0  127.0.0.1.5432         *.*                    LISTEN

If it's just '127.0.0.1' it just lists the tcp4 line.

> and psql -h 127.0.0.1 still fails?

Yes.

> is lo0 still there (ifconfig)?

~ ifconfig lo0
lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> mtu 16384
        options=3<RXCSUM,TXCSUM>
        inet6 ::1 prefixlen 128
        inet 127.0.0.1 netmask 0xff000000
        inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
        nd6 options=1<PERFORMNUD>