Re: Cannot reach pg server using -h localhost

Adrian Klaver <adrian.klaver@xxxxxxxxxxx> · Tue, 21 Jul 2015 11:25:58 -0700

On 07/21/2015 11:00 AM, Fritz Meissner wrote:
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>

So what happens if you?:

ping 127.0.0.1
ping localhost

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general