Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 494DF63262B for ; Thu, 8 Jan 2009 01:50:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10492-09-2 for ; Thu, 8 Jan 2009 01:50:50 -0400 (AST) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by mail.postgresql.org (Postfix) with ESMTP id 54F7063259A for ; Thu, 8 Jan 2009 01:50:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from viefep18-int.chello.at (viefep13-int.chello.at [62.179.121.33]) by mx3.hub.org (Postfix) with ESMTP id 6B0B337B68B for ; Thu, 8 Jan 2009 01:50:44 -0400 (AST) Received: from edge05.upc.biz ([192.168.13.212]) by viefep13-int.chello.at (InterMail vM.7.09.01.00 201-2219-108-20080618) with ESMTP id <20090108055027.OGJB17187.viefep13-int.chello.at@edge05.upc.biz>; Thu, 8 Jan 2009 06:50:27 +0100 Received: from [192.168.0.100] ([89.134.230.181]) by edge05.upc.biz with edge id 0tqR1b02U3vUdip05tqSu4; Thu, 08 Jan 2009 06:50:27 +0100 X-SourceIP: 89.134.230.181 Message-ID: <49659421.6060000@shopzeus.com> Date: Thu, 08 Jan 2009 06:50:25 +0100 From: Laszlo Nagy User-Agent: Thunderbird 2.0.0.18 (X11/20081125) MIME-Version: 1.0 To: Tom Lane , pgsql-admin@postgresql.org Subject: Re: rebellious pg stats collector (reopened case) References: <49479876.8040607@shopzeus.com> <20081216134542.GH4741@alvh.no-ip.org> <494B614C.5060808@shopzeus.com> <20081219130446.GC4278@alvh.no-ip.org> <494F67D2.3090406@shopzeus.com> <6938.1229952228@sss.pgh.pa.us> <20081222132721.GC10220@alvh.no-ip.org> <7117.1229952970@sss.pgh.pa.us> <4958851B.8060500@shopzeus.com> <7721.1230564393@sss.pgh.pa.us> <495A1F4D.6050205@shopzeus.com> In-Reply-To: <495A1F4D.6050205@shopzeus.com> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.125 tagged_above=0 required=5 tests=DNS_FROM_RFC_BOGUSMX=2.125 X-Spam-Level: ** X-Archive-Number: 200901/20 X-Sequence-Number: 31067 Laszlo Nagy írta: > >> alive". Otherwise you'll have trouble with the collector not stopping >> when you want it to. Look into src/backend/storage/ipc/pmsignal.c: >> >> - return (getppid() == PostmasterPid); >> + return (getppid() != 1); >> >> (Obviously this is a hack, but it should work on any Unixish system) >> Sorry for coming back so late. I changed this, and reinstalled postgresql but it won't start. Some messages from the log: Jan 8 00:40:29 shopzeus postgres[80522]: [3814-1] FATAL: the database system is in recovery mode Jan 8 00:40:30 shopzeus postgres[80559]: [3849-1] FATAL: the database system is in recovery mode Jan 8 00:40:30 shopzeus postgres[80632]: [3917-1] FATAL: the database system is in recovery mode Jan 8 00:40:31 shopzeus postgres[80662]: [3946-1] FATAL: the database system is in recovery mode Jan 8 00:40:31 shopzeus postgres[80700]: [3981-1] FATAL: the database system is in recovery mode Jan 8 00:40:31 shopzeus postgres[80734]: [4014-1] FATAL: the database system is in recovery mode Jan 8 00:40:31 shopzeus postgres[80738]: [4017-1] FATAL: the database system is in recovery mode Jan 8 00:40:32 shopzeus postgres[80768]: [4046-1] FATAL: the database system is in recovery mode Jan 8 00:40:32 shopzeus postgres[80802]: [4078-1] FATAL: the database system is in recovery mode Jan 8 00:40:32 shopzeus postgres[80806]: [4079-1] WARNING: terminating connection because of crash of another server process Jan 8 00:40:32 shopzeus postgres[80806]: [4079-2] DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server Jan 8 00:40:32 shopzeus postgres[80806]: [4079-3] process exited abnormally and possibly corrupted shared memory. Jan 8 00:40:32 shopzeus postgres[80806]: [4079-4] HINT: In a moment you should be able to reconnect to the database and repeat your command. Jan 8 00:40:32 shopzeus postgres[80835]: [4109-1] FATAL: the database system is in recovery mode Jan 8 00:40:32 shopzeus postgres[80837]: [4110-1] FATAL: the database system is in recovery mode Jan 8 00:40:33 shopzeus postgres[80870]: [4141-1] FATAL: the database system is in recovery mode Jan 8 00:40:33 shopzeus postgres[80900]: [4170-1] FATAL: the database system is in recovery mode Jan 8 00:40:34 shopzeus postgres[80938]: [4205-1] FATAL: the database system is in recovery mode Jan 8 00:40:34 shopzeus postgres[80967]: [4233-1] FATAL: the database system is in recovery mode (I had to reinstall the original version because it will be used today.)