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

From John R Pierce
Subject Re: BUG #7632: Postgres binds to all IPs even when listen_addresses="localhost"
Date
Msg-id 509191C3.5080901@hogranch.com
Whole thread Raw
In response to Re: BUG #7632: Postgres binds to all IPs even when listen_addresses="localhost"  (Paul Jungwirth <pj@illuminatedcomputing.com>)
List pgsql-bugs
On 10/31/12 1:43 PM, Paul Jungwirth wrote:
>> This behaves as expected for me.  I'm wondering whether your DNS
>> >server is resolving "localhost" as meaning both 127.0.0.1 and your
>> >public IP.  "dig localhost." might be illuminating.
> Wow, that is some psychic debugging. Sure enough, my /etc/hosts is
> setting localhost to both 127.0.0.1 and my other IP. Using
> `listen_addresses = '127.0.0.1'` fixes the problem.


fix your /etc/hosts .... thats an artifact of the #@$@# RHEL installer,
if the network isn't properly configured at install time, it loves to do
that with the hostname.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-bugs by date:

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