X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DCF29D1B1CE for ; Mon, 19 Jul 2004 03:39:12 -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 69794-03 for ; Mon, 19 Jul 2004 06:39:09 +0000 (GMT) Received: from cmailg3.svr.pol.co.uk (cmailg3.svr.pol.co.uk [195.92.195.173]) by svr1.postgresql.org (Postfix) with ESMTP id DBB7AD1B1AE for ; Mon, 19 Jul 2004 03:39:07 -0300 (ADT) Received: from modem-2870.llama.dialup.pol.co.uk ([217.135.187.54] helo=[192.168.0.100]) by cmailg3.svr.pol.co.uk with esmtp (Exim 4.14) id 1BmRnj-0005yO-Kr; Mon, 19 Jul 2004 07:39:03 +0100 Subject: Re: [HACKERS] Point in Time Recovery From: Simon Riggs To: Tom Lane Cc: Bruce Momjian , pgsql-patches@postgresql.org In-Reply-To: <8192.1090206830@sss.pgh.pa.us> References: <200407172015.i6HKFLK17349@candle.pha.pa.us> <25995.1090127083@sss.pgh.pa.us> <1090182052.17493.18904.camel@stromboli> <8192.1090206830@sss.pgh.pa.us> Content-Type: text/plain Organization: 2nd Quadrant Message-Id: <1090219142.17493.22023.camel@stromboli> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-7) Date: Mon, 19 Jul 2004 07:39:03 +0100 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/301 X-Sequence-Number: 11971 On Mon, 2004-07-19 at 04:13, Tom Lane wrote: > Simon Riggs writes: > > When archiver starts the FIRST thing it does is run a test to confirm > > that the command string works, so setting archive_command to '' would > > simply generate an error. > > No, it would do no such thing; the test cannot really tell anything more > than whether system("foo") returns zero ... and at least on my machine, > system("") returns zero. It certainly does not prove that any data went > to anyplace safe. > > I diked that test out of the committed patch because I felt it cluttered > the archive area without actually proving anything of interest. We can > revisit the point if you like. > If the test doesn't guarantee success, then it needs to go.... Thanks for removing it. Best Regards, Simon Riggs