X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C9DF8D1B220 for ; Thu, 15 Jul 2004 09:19:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36097-08 for ; Thu, 15 Jul 2004 12:19:13 +0000 (GMT) Received: from tama5.ecl.ntt.co.jp (tama5.ecl.ntt.co.jp [129.60.39.102]) by svr1.postgresql.org (Postfix) with ESMTP id 6A25DD1B1C7 for ; Thu, 15 Jul 2004 09:19:03 -0300 (ADT) Received: from vcs3.rdh.ecl.ntt.co.jp (vcs3.rdh.ecl.ntt.co.jp [129.60.39.110]) by tama5.ecl.ntt.co.jp (8.12.11/8.12.11) with ESMTP id i6FCJ8RX026664; Thu, 15 Jul 2004 21:19:08 +0900 (JST) Received: from mfs3.rdh.ecl.ntt.co.jp (localhost [127.0.0.1]) by vcs3.rdh.ecl.ntt.co.jp (8.12.11/8.12.11) with ESMTP id i6FCJ7OK001135; Thu, 15 Jul 2004 21:19:07 +0900 (JST) Received: from mfs3.rdh.ecl.ntt.co.jp (localhost [127.0.0.1]) by mfs3.rdh.ecl.ntt.co.jp (8.12.11/8.12.11) with ESMTP id i6FCJ64a005462; Thu, 15 Jul 2004 21:19:07 +0900 (JST) Received: from nttmail3.ecl.ntt.co.jp ([129.60.39.100]) by mfs3.rdh.ecl.ntt.co.jp (8.12.11/8.12.11) with ESMTP id i6FCJ66E005457; Thu, 15 Jul 2004 21:19:06 +0900 (JST) Received: from dmailsv1.y.ecl.ntt.co.jp (dmailsv1.y.ecl.ntt.co.jp [129.60.53.14]) by nttmail3.ecl.ntt.co.jp (8.12.11/8.12.11) with ESMTP id i6FCJ6ok007189; Thu, 15 Jul 2004 21:19:06 +0900 (JST) Received: from mailsv03.y.ecl.ntt.co.jp by dmailsv1.y.ecl.ntt.co.jp (8.12.11/dmailsv-1.1c) with ESMTP id i6FCJ5Mj020691; Thu, 15 Jul 2004 21:19:05 +0900 (JST) Received: from localhost by mailsv03.y.ecl.ntt.co.jp (8.12.11/Lab-1.2a) with ESMTP id i6FCJ2Ug016501; Thu, 15 Jul 2004 21:19:05 +0900 (JST) Date: Thu, 15 Jul 2004 21:16:58 +0900 From: HISADAMasaki To: Simon Riggs Subject: Re: Point in Time Recovery Cc: pgsql-hackers@postgresql.org In-Reply-To: <1089760416.17493.3327.camel@stromboli> References: <200407132242.i6DMgg612564@candle.pha.pa.us> <1089760416.17493.3327.camel@stromboli> Message-Id: <20040715210816.E8A3.HISADA.MASAKI@lab.ntt.co.jp> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Mailer: Becky! ver. 2.09.01 [ja] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/801 X-Sequence-Number: 56362 Dear Simon, I've just tested pitr_v5_2.patch and got an error message during archiving process as follows. -- begin LOG: archive command="cp /usr/local/pgsql/data/pg_xlog/0000000000000000 /tmp",return code=-1 -- end The command called in system(3) works, but it returns -1. system(3) can not get right exit code from its child process, when SIGCHLD is set as SIG_IGN. So I did following change to pgarch_Main() in pgarch.c -- line 236 --- - pgsignal(SIGCHLD, SIG_IGN); -- line 236 --- + pgsignal(SIGCHLD, SIG_DFL); After that, the error message doen't come out and it seems to be working propery. Regards, Hisada, Masaki On Wed, 14 Jul 2004 00:13:37 +0100 Simon Riggs wrote: > PITR Patch v5_1 just posted has Point in Time Recovery working.... > > Still some rough edges....but we really need some testers now to give > this a try and let me know what you think. > > Klaus Naumann and Mark Wong are the only [non-committers] to have tried > to run the code (and let me know about it), so please have a look at > [PATCHES] and try it out. > > Many thanks, > > Simon Riggs > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend -- HISADA, Masaki