Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets - Mailing list pgsql-admin

"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