From: Tom Lane <tgl@sss.pgh.pa.us>
To: Daniel J. Summers <daniel.lists@djs-consulting.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets
Date: Mon, 03 May 2010 10:20:49 -0400
Message-ID: <15098.1272896449@sss.pgh.pa.us> (raw)
In-Reply-To: <4BDED7E2.5060304@djs-consulting.com>
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>
"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?
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
RX packets:621786 errors:0 dropped:0 overruns:0 frame:0
TX packets:621786 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:149095072 (142.1 MiB) TX bytes:149095072 (142.1 MiB)
regards, tom lane
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: tgl@sss.pgh.pa.us, daniel.lists@djs-consulting.com
Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets
In-Reply-To: <15098.1272896449@sss.pgh.pa.us>
* 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