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

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@aklaver.com