| From: | Fritz Meissner <fritz(dot)meissner(at)gmail(dot)com> |
|---|---|
| To: | Chris Mair <chris(at)1006(dot)org> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Cannot reach pg server using -h localhost |
| Date: | 2015-07-21 18:00:17 |
| Message-ID: | CAGUYmUaotNopHpRkC+xuJitg=K1P5nvehz7TTZ8D44dvHXRBLQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | AI Rumman | 2015-07-21 18:01:03 | Re: Setting up HA postgresql |
| Previous Message | Aviel Buskila | 2015-07-21 17:55:40 | Re: Setting up HA postgresql |