Received: from maia.hub.org (maia-1.hub.org [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 98FBF632F48 for ; Wed, 5 May 2010 00:11:25 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 93499-10 for ; Wed, 5 May 2010 03:11:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tcms.us (tcms.us [174.143.154.125]) by mail.postgresql.org (Postfix) with ESMTP id 38ED4632C94 for ; Wed, 5 May 2010 00:11:18 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by tcms.us (Postfix) with ESMTP id 9D676224643 for ; Wed, 5 May 2010 03:11:17 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at tcms.us Received: from tcms.us ([127.0.0.1]) by localhost (tcms.us [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id ZAEZZ5ZVIK+L for ; Wed, 5 May 2010 03:11:14 +0000 (UTC) Received: from [192.168.0.105] (c-68-35-134-229.hsd1.nm.comcast.net [68.35.134.229]) (Authenticated sender: daniel@summershome.org) by tcms.us (Postfix) with ESMTPA id C94E5224040 for ; Wed, 5 May 2010 03:11:13 +0000 (UTC) Message-ID: <4BE0E1CD.4090600@djs-consulting.com> Date: Wed, 05 May 2010 03:11:09 +0000 From: "Daniel J. Summers" User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.9) Gecko/20100423 Thunderbird/3.0.4 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Ubuntu 10.04 - Cannot Create TCP/IP Sockets 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> <4BDFA003.2080706@djs-consulting.com> <11068.1272983067@sss.pgh.pa.us> In-Reply-To: <11068.1272983067@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201005/45 X-Sequence-Number: 34518 On 05/04/2010 02:24 PM, Tom Lane wrote: > > We might be able to learn something if you strace the postmaster > while it's trying to start up with "localhost" as the setting. > There will be a lot of output, so send it to a file. Look for > the bind() calls --- on my Linux box the relevant part of the > trace looks like this: > I did an "strace -o strace.txt /etc/init.d/postgresql-8.4 start" *, but the only "socket" that was in it was in the error message. I modified /usr/share/postgresql-common/init.d-functions to add strace to the pg_ctlcluster call **, and there are lots of references to "socket", but it doesn't look like it's having much success. * Output is at http://djs-consulting.com/strace.txt ** Output is at http://djs-consulting.com/pg_trace.txt Daniel