Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets

"Daniel J. Summers" <daniel(dot)lists(at)djs-consulting(dot)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