BUG #7632: Postgres binds to all IPs even when listen_addresses="localhost" - Mailing list pgsql-bugs

From pj@illuminatedcomputing.com
Subject BUG #7632: Postgres binds to all IPs even when listen_addresses="localhost"
Date
Msg-id E1TTe7S-0003v2-4u@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #7632: Postgres binds to all IPs even when listen_addresses="localhost"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7632
Logged by:          Paul Jungwirth
Email address:      pj@illuminatedcomputing.com
PostgreSQL version: 9.1.6
Operating system:   Ubuntu 12.04 LTS, x86_64
Description:        =


After a default install of Postgres, I see that it's binding not just to
localhost, but also to my public IP. The port is reported open by nmap, and
I see this:

    # netstat -an | grep 5432
    tcp        0      0 66.175.223.51:5432      0.0.0.0:*              =

LISTEN     =

    tcp        0      0 127.0.0.1:5432          0.0.0.0:*              =

LISTEN     =


Postgres still binds to the public IP even after I uncomment the
`listen_addresses` line at `/etc/postgresql/9.1/main/postgresql.conf`, set
it to the following, and do `service postgresql restart`:

    listen_addresses =3D 'localhost'

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #7631: tcp_keepalives_* parameters ignored in postgresql.conf - related to 9.0.10 or 9.0.9 patch?
Next
From: Tom Lane
Date:
Subject: Re: BUG #7632: Postgres binds to all IPs even when listen_addresses="localhost"