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 068FBD1B178 for ; Sun, 18 Jul 2004 03:45:46 -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 31393-10 for ; Sun, 18 Jul 2004 06:45:50 +0000 (GMT) Received: from linda-3.paradise.net.nz (bm-3a.paradise.net.nz [202.0.58.22]) by svr1.postgresql.org (Postfix) with ESMTP id 1A20AD1B16A for ; Sun, 18 Jul 2004 03:45:42 -0300 (ADT) Received: from smtp-2.paradise.net.nz (smtp-2b.paradise.net.nz [202.0.32.211]) by linda-3.paradise.net.nz (Paradise.net.nz) with ESMTP id <0I11000KEC4BVC@linda-3.paradise.net.nz> for pgsql-hackers@postgresql.org; Sun, 18 Jul 2004 18:45:48 +1200 (NZST) Received: from coretech.co.nz (203-96-145-208.adsl.paradise.net.nz [203.96.145.208]) by smtp-2.paradise.net.nz (Postfix) with ESMTP id A15259E6BD; Sun, 18 Jul 2004 18:45:47 +1200 (NZST) Date: Sun, 18 Jul 2004 18:48:09 +1200 From: Mark Kirkwood Subject: Re: PITR COPY Failure (was Point in Time Recovery) In-reply-to: <40FA0F93.8010607@coretech.co.nz> To: Mark Kirkwood Cc: Simon Riggs , pgsql-hackers@postgresql.org Message-id: <40FA1D29.1040100@coretech.co.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii 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> 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/936 X-Sequence-Number: 56497 There are some silly bugs in the script: - forgot to export PGDATA and PATH after changing them - forgot to mention the need to edit test.sql (COPY line needs path to dump file) Apologies - I will submit a fixed version a little later regards Mark Mark Kirkwood wrote: > > A script to run the whole business can be found here : > > http://homepages.paradise.net.nz/markir/download/pitr-bug.tar.gz > > (It will need a bit of editing for things like location of Pg, PGDATA, > and you will need to make your own data file) >