Re: Stats Collector Won't Start - Mailing list pgsql-general

From Brad Nicholson
Subject Re: Stats Collector Won't Start
Date
Msg-id 1161201942.4138.18.camel@dba5.int.libertyrms.com
Whole thread Raw
In response to Re: Stats Collector Won't Start  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Stats Collector Won't Start  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote:
> Brad Nicholson <bnichols@ca.afilias.info> writes:
> > On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
> >> Would you try strace'ing postmaster start to see what gets passed to the
> >> socket() and bind() calls just before this message comes out?
>
> > Here is the relative output from truss.
>
> > socket(2, 2, 0)                                 = 7
> > bind(7, 0x00000001100E3BF0, 16)                 Err#13 EACCES
>
> Well, that's pretty odd --- I'd have expected to see something involving
> 127.0.0.1 (ie, 7F000001 in one byte order or another).  Does your
> /etc/hosts file map "localhost" to something other than 127.0.0.1?

Nope, it maps localhost to 127.0.0.1

> Also, do regular connections to this postmaster work across TCP/IP?
> If getaddrinfo() is broken I'd expect there to be problems binding
> to the postmaster's listen socket too ...

Yes, TCP/IP connections work fine.

--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stats Collector Won't Start
Next
From: Jonathan Hedstrom
Date:
Subject: Re: column refernce question