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 24123D1B2E0 for ; Tue, 20 Jul 2004 06:43:22 -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 93302-04 for ; Tue, 20 Jul 2004 09:43:21 +0000 (GMT) Received: from linda-1.paradise.net.nz (bm-1a.paradise.net.nz [202.0.58.20]) by svr1.postgresql.org (Postfix) with ESMTP id 04D1DD1B181 for ; Tue, 20 Jul 2004 06:43:18 -0300 (ADT) Received: from smtp-1.paradise.net.nz (smtp-1a.paradise.net.nz [202.0.32.194]) by linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id <0I1500FRV9O6ZK@linda-1.paradise.net.nz> for pgsql-hackers@postgresql.org; Tue, 20 Jul 2004 21:43:19 +1200 (NZST) Received: from coretech.co.nz (218-101-12-189.paradise.net.nz [218.101.12.189]) by smtp-1.paradise.net.nz (Postfix) with ESMTP id D07818279B; Tue, 20 Jul 2004 21:43:17 +1200 (NZST) Date: Tue, 20 Jul 2004 21:45:39 +1200 From: Mark Kirkwood Subject: Re: PITR COPY Failure (was Point in Time Recovery) In-reply-to: <3607.1090296869@sss.pgh.pa.us> To: Tom Lane , Simon Riggs Cc: pgsql-hackers@postgresql.org Message-id: <40FCE9C3.3080502@coretech.co.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.6) Gecko/20040429 References: <200407141555.i6EFtnk22984@mail.osdl.org> <1089833620.17493.4624.camel@stromboli> <40F5E14A.4090003@coretech.co.nz> <1089875702.17493.5539.camel@stromboli> <40F652C6.4070007@coretech.co.nz> <1089935215.17493.6906.camel@stromboli> <40FA0F93.8010607@coretech.co.nz> <40FC6BF2.5050701@coretech.co.nz> <3607.1090296869@sss.pgh.pa.us> 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/1019 X-Sequence-Number: 56580 Great that it's not fundamental - and hopefully with this discovery, the probability you mentioned is being squashed towards zero a bit more :-) Don't let this early bug detract from what is really a superb piece of work! regards Mark Tom Lane wrote: >In any case this isn't a fundamental bug, just an insufficiently >smart safety check. But thanks for finding it! As is, the code has >a nonzero probability of failure in the field :-( and I don't know >how we'd have tracked it down without a reproducible test case. > > > >