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]

 



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,


Edoardo



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