Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 9A98E2E01E5 for ; Wed, 28 May 2008 22:07:01 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 39316-02-3 for ; Wed, 28 May 2008 22:06:24 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.177]) by developer.postgresql.org (Postfix) with ESMTP id 19D822E00BF for ; Wed, 28 May 2008 21:36:12 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id n4so3458284wag.5 for ; Wed, 28 May 2008 17:36:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=RVSp+P0Cn4mKyOmF+DftFOXQ3rP0j3uzbZyeYWv4ptg=; b=IgnCkvf/+QvXKvvYGbtQ0ZT+EUQfzaFO6o3FLvyJusgxTIHMhYwnobkei/9R9NFnRqovJbmnfvw26sXOWreus6/i/s/9gCIGT5Tp4nSrKQhJef3g0fc/0b71tHMGr9Ttdji22yiBDpIxIOiIhkPgmYOczSnx+1RUAsHnheBKHlQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=EdZtX30vB/l//PsoIBZ6U9g2/Qr+pBQB5L1IyPvnmO6f1OQlF4I/3St5Y4PXKHL4guCK1RkCIwikUD+9oIn/4r9oThGbREr0LodJRWEEr1FpyVG5z39TJbJM0dIniepDgzRWDJ03KkwGUZHhByzhCI219B3fxVq5LyomiZVNkfw= Received: by 10.114.109.1 with SMTP id h1mr3558453wac.35.1212021371316; Wed, 28 May 2008 17:36:11 -0700 (PDT) Received: by 10.114.130.17 with HTTP; Wed, 28 May 2008 17:36:11 -0700 (PDT) Message-ID: Date: Wed, 28 May 2008 18:36:11 -0600 From: "Scott Marlowe" To: "Naomi Walker" Subject: Re: statistics collector Log message Cc: "pgsql-admin@postgresql.org" In-Reply-To: <483DE8CC.3080205@mhs.mphasis.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <483DE8CC.3080205@mhs.mphasis.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/232 X-Sequence-Number: 29316 On Wed, May 28, 2008 at 5:20 PM, Naomi Walker wrote: > > > When starting up a second instance of postgres on a server, received: > > > > LOG: could not bind socket for statistics collector: Cannot assign requested address > > LOG: trying another address for the statistics collector Sounds like they're both trying to start up on the same port. Change the port number in the second postgres' postgresql.conf (or change the startup args...) and see if that helps.