BUG #7632: Postgres binds to all IPs even when listen_addresses="localhost"

From: pj(at)illuminatedcomputing(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7632: Postgres binds to all IPs even when listen_addresses="localhost"
Date: 2012-10-31 19:38:30
Message-ID: E1TTe7S-0003v2-4u@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7632
Logged by: Paul Jungwirth
Email address: pj(at)illuminatedcomputing(dot)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 = 'localhost'

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-10-31 20:06:52 Re: BUG #7632: Postgres binds to all IPs even when listen_addresses="localhost"
Previous Message Tom Lane 2012-10-31 18:09:12 Re: BUG #7631: tcp_keepalives_* parameters ignored in postgresql.conf - related to 9.0.10 or 9.0.9 patch?