From: Daniel J. Summers <daniel.lists@djs-consulting.com>
To: pgsql-admin@postgresql.org
Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets
Date: Tue, 04 May 2010 04:18:11 +0000
Message-ID: <4BDFA003.2080706@djs-consulting.com> (raw)
In-Reply-To: <15098.1272896449@sss.pgh.pa.us>
References: <4BDE46F4.4070401@djs-consulting.com>
<1CA7FF980DA3824F9A5C31532B7A40DCCDCE01FD@LCXCLMB01.LCDS.LOC.GOV>
<4BDEC707.1090403@gmail.com>
<14337.1272894755@sss.pgh.pa.us>
<4BDED7E2.5060304@djs-consulting.com>
<15098.1272896449@sss.pgh.pa.us>
On 05/03/2010 02:20 PM, Tom Lane wrote:
> "Daniel J. Summers"<daniel.lists@djs-consulting.com> writes:
>
>> On 05/03/2010 01:52 PM, Tom Lane wrote:
>>
>>> Does it work if you change listen_addresses to '*' or '127.0.0.1' ?
>>>
>
>> Bingo - changing it to "*" got it started. :)
>>
> OK, what about 127.0.0.1? Given that "dig localhost" returns that,
> it *should* behave the same, but obviously something here is not
> behaving as expected. Also, after you start it with '*', does
> "psql -h localhost" work?
>
Yes on both accounts. When I had 127.0.0.1 or *, it both started up,
and psql -h localhost gave me a password prompt.
> I'm guessing that there is something funny about the way your local
> loopback is configured. It might be useful to look at "ifconfig lo".
> On a Fedora machine I get
>
> 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:16436 Metric:1
>
Mine's a carbon copy of that. It's strange.
Let me know if there are any other commands you'd like for me to run.
The original problem is solved, but I'd be happy to help find the
disconnect (if there is one - and pardon the pun). :)
Daniel
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: daniel.lists@djs-consulting.com
Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets
In-Reply-To: <4BDFA003.2080706@djs-consulting.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox