Re: psql connection via localhost or 127.0.0.1 - Mailing list pgsql-general

On 11/6/2014 7:36 AM, Edoardo Panfili wrote:
>> grep localhost /etc/hosts
> 127.0.0.1       localhost
> 127.0.1.1       host.host     host

wahaaaa?

whats the output of ...

# ifconfig lo
lo        Link encap:Local Loopback
           inet addr:127.0.0.1  Mask:255.0.0.0
           inet6 addr: ::1/128 Scope:Host
           UP LOOPBACK RUNNING  MTU:65536  Metric:1
           RX packets:18367154 errors:0 dropped:0 overruns:0 frame:0
           TX packets:18367154 errors:0 dropped:0 overruns:0 carrier:0
           collisions:0 txqueuelen:0
           RX bytes:23279985092 (21.6 GiB)  TX bytes:23279985092 (21.6 GiB)


note that net mask?    the loopback interface is the entire 127.0.0.0/8
network    you can't put a host at 127.0.1.x and expect it to work right.

you should instead use one of the RFC1918 reserved subnets for a private
network, within 10.0.0.0/8 or 172.16.0.0/12, or 192.168.0.0/16  (you can
use these with any mask size you want, for instance, /24 is usually used
with 192.168.x.y)



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast