Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A9C306330D1 for ; Mon, 3 May 2010 11:21:01 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 06349-01 for ; Mon, 3 May 2010 14:20:54 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id F0646632974 for ; Mon, 3 May 2010 11:20:53 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o43EKnOb015099; Mon, 3 May 2010 10:20:49 -0400 (EDT) To: "Daniel J. Summers" cc: pgsql-admin@postgresql.org Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets 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> Comments: In-reply-to "Daniel J. Summers" message dated "Mon, 03 May 2010 14:04:18 -0000" Date: Mon, 03 May 2010 10:20:49 -0400 Message-ID: <15098.1272896449@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.88 tagged_above=-10 required=5 tests=AWL=0.030, BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/27 X-Sequence-Number: 34500 "Daniel J. Summers" 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