Search Postgresql Archives

Re: psql connection via localhost or 127.0.0.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx


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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux