Re: psql connection via localhost or 127.0.0.1

On 11/06/2014 07:57 AM, Edoardo Panfili wrote:
> Il 06/11/14 16:47, John R Pierce ha scritto:
>> 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)
>>
> # 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:3306 errors:0 dropped:0 overruns:0 frame:0
>            TX packets:3306 errors:0 dropped:0 overruns:0 carrier:0
>            collisions:0 txqueuelen:0
>            RX bytes:2544659 (2.4 MiB)  TX bytes:2544659 (2.4 MiB)
>
>> 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)
> I can't figure why 127.0.1.1 is there (I will remove it) is an (almost)
> new installation on a virtual machine,

See the link I sent to John.

>
>
> Edoardo
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com