Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D918B64FD7D for ; Tue, 30 Dec 2008 09:17:44 -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 02216-03 for ; Tue, 30 Dec 2008 09:17:41 -0400 (AST) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by mail.postgresql.org (Postfix) with ESMTP id C1CB164FC57 for ; Tue, 30 Dec 2008 09:17:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from viefep18-int.chello.at (viefep15-int.chello.at [62.179.121.35]) by mx3.hub.org (Postfix) with ESMTP id 1ECAB37B7D5 for ; Tue, 30 Dec 2008 09:17:40 -0400 (AST) Received: from edge01.upc.biz ([192.168.13.236]) by viefep15-int.chello.at (InterMail vM.7.09.01.00 201-2219-108-20080618) with ESMTP id <20081230131704.MAOQ1325.viefep15-int.chello.at@edge01.upc.biz>; Tue, 30 Dec 2008 14:17:04 +0100 Received: from [192.168.1.104] ([89.134.230.11]) by edge01.upc.biz with edge id xRH11a07G0FQLHV01RH32V; Tue, 30 Dec 2008 14:17:04 +0100 X-SourceIP: 89.134.230.11 Message-ID: <495A1F4D.6050205@shopzeus.com> Date: Tue, 30 Dec 2008 14:17:01 +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> In-Reply-To: <7721.1230564393@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit 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: 200812/200 X-Sequence-Number: 31033 > 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) > Thanks. I'm going to try this next weekend (when nobody works on the database) and come back with the results.