X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C4BC9D1B457 for ; Thu, 1 Jan 2004 18:07:34 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 30147-09 for ; Thu, 1 Jan 2004 14:06:45 -0400 (AST) Received: from quality.qadas.com (quality.qadas.com [204.227.16.4]) by svr1.postgresql.org (Postfix) with ESMTP id 5F742D1B43A for ; Thu, 1 Jan 2004 14:06:44 -0400 (AST) Received: from quality.qadas.com (localhost [127.0.0.1]) by quality.qadas.com (8.12.10/8.12.10) with ESMTP id i01I6cJM029568; Thu, 1 Jan 2004 11:06:38 -0700 (MST) Received: (from mfuhr@localhost) by quality.qadas.com (8.12.10/8.12.10/Submit) id i01I6cHc029567; Thu, 1 Jan 2004 11:06:38 -0700 (MST) Date: Thu, 1 Jan 2004 11:06:38 -0700 From: Michael Fuhr To: Denis Grannell Cc: pgsql-admin@postgresql.org Subject: Re: could not bind socket for statistics collector: Message-ID: <20040101110638.A25482@quality.qadas.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: ; from dgrannell@web.de on Thu, Jan 01, 2004 at 04:58:39PM +0100 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/2 X-Sequence-Number: 11865 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". > My setup is: > > OS : Solaris 9(sparc) > Postgres Version: 7.4.1 (upgraded from 7.3.2) [snip] > I read somewhere that, to fix this, all I would > need to do would be to uncomment the line > "::1 localhost" in /etc/inet/ipnodes and restart > the postmaster. However this line is already > uncommented on my system, also I have been using > postgres 7.3.x versions on this exact same system > for well over a year without any errors. The following message suggests that the solution is to comment, not uncomment, the "::1 localhost" line in /etc/inet/ipnodes: http://archives.postgresql.org/pgsql-hackers/2003-11/msg00744.php I commented out that line on my Solaris 9 box, and the statistics collector was then able to start. -- Michael Fuhr http://www.fuhr.org/~mfuhr/