From: Michael Fuhr <mike@fuhr.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Denis Grannell <dgrannell@web.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: could not bind socket for statistics collector:
Date: Thu, 1 Jan 2004 11:50:21 -0700
Message-ID: <20040101115021.A4510@quality.qadas.com> (raw)
In-Reply-To: <22021.1072981636@sss.pgh.pa.us>
References: <IBELIFHJOADELLGIAJFDAEKLCCAA.dgrannell@web.de>
<20040101110638.A25482@quality.qadas.com>
<22021.1072981636@sss.pgh.pa.us>
On Thu, Jan 01, 2004 at 01:27:16PM -0500, Tom Lane wrote:
> > On Thu, Jan 01, 2004 at 04:58:39PM +0100, Denis Grannell wrote:
> >> I have just upgraded to 7.4.1 and since restarting
> >> postmaster I am getting the following error message
> >> in the logfile:
> >> "could not bind socket for statistics collector:
> >> "Cannot assign requested address".
>
> Is it actually an ERROR, or just a LOG? If the latter, ignore it.
> There's no problem unless you also see
> "LOG: disabling statistics collector for lack of working socket"
Dang...I'm not the original poster, but I thought I remembered the
statistics collector not starting when I saw the "could not bind
socket" message. However, I just backed out the "fix" I mentioned in
my previous post (the fix being to comment out "::1 localhost" from
/etc/inet/ipnodes), and although the "could not bind socket" message is
now logged, the statistics collector nevertheless appears to be running.
Must be a memory fault on my part, unless that behavior changed recently.
> Making the message disappear would require getting your kernel and
> libc on the same page about whether IPv6 is supported or not. I don't
> know enough about Solaris to know how/where to fix that.
That's what commenting out "::1 localhost" from /etc/inet/ipnodes appears
to do.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mike@fuhr.org, tgl@sss.pgh.pa.us, dgrannell@web.de
Subject: Re: could not bind socket for statistics collector:
In-Reply-To: <20040101115021.A4510@quality.qadas.com>
References: <IBELIFHJOADELLGIAJFDAEKLCCAA.dgrannell@web.de> <20040101110638.A25482@quality.qadas.com> <22021.1072981636@sss.pgh.pa.us> <20040101115021.A4510@quality.qadas.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox