Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0031C6327C1 for ; Thu, 26 Mar 2009 07:00:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 66749-06 for ; Thu, 26 Mar 2009 07:00:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp.sanger.ac.uk (smtp.sanger.ac.uk [193.62.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 3898F632196 for ; Thu, 26 Mar 2009 07:00:26 -0300 (ADT) Received: from intmail1b.internal.sanger.ac.uk ([172.17.56.130] helo=smtp.sanger.ac.uk) by mailrelay.internal.sanger.ac.uk with esmtp (Exim 4.69) (envelope-from ) id 1Lmlqp-0005BA-Gu for pgsql-admin@postgresql.org; Thu, 26 Mar 2009 09:26:15 +0000 Received: from exchsrv2.internal.sanger.ac.uk ([172.22.12.37]) by intmail1b.internal.sanger.ac.uk with esmtp (Exim 4.69) (envelope-from ) id 1Lmlqp-0006wS-1b for pgsql-admin@postgresql.org; Thu, 26 Mar 2009 09:26:15 +0000 Received: from [127.0.0.1] ([172.19.31.48]) by exchsrv2.internal.sanger.ac.uk with Microsoft SMTPSVC(6.0.3790.1830); Thu, 26 Mar 2009 09:26:14 +0000 Message-ID: <49CB4A35.1030002@sanger.ac.uk> Date: Thu, 26 Mar 2009 09:26:13 +0000 From: Tony Webb User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pg_ctlcluster not logging error (memory problem likely) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 26 Mar 2009 09:26:14.0546 (UTC) FILETIME=[E8C28F20:01C9ADF4] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/230 X-Sequence-Number: 31730 Hi, I'm trying to find out why my cluster won't start. It looks like I'm pushing up max_connections too high although I think my memory and semaphore settings are OK. Thing is, when the cluster fails to start I can't see any errors in pg_log or in /var/log/messages. When the cluster is up and running it seems to write normally to these locations. Could pg_ctlcluster be writing somewhere else? can I do something to see more verbose messages (more than the empty string) other than setting log parameters in postgres.conf? I'm running 8.3 on Debian btw. Cheers Pif -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE.