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 6EFDFD1B18A for ; Sun, 18 Jul 2004 05:03:20 -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 49337-10 for ; Sun, 18 Jul 2004 08:03:24 +0000 (GMT) Received: from linda-2.paradise.net.nz (bm-2a.paradise.net.nz [202.0.58.21]) by svr1.postgresql.org (Postfix) with ESMTP id 6D15AD1B182 for ; Sun, 18 Jul 2004 05:03:15 -0300 (ADT) Received: from smtp-2.paradise.net.nz (smtp-2b.paradise.net.nz [202.0.32.211]) by linda-2.paradise.net.nz (Paradise.net.nz) with ESMTP id <0I1100LCHFPLJR@linda-2.paradise.net.nz> for pgsql-hackers@postgresql.org; Sun, 18 Jul 2004 20:03:21 +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 7B1769E674; Sun, 18 Jul 2004 20:03:21 +1200 (NZST) Date: Sun, 18 Jul 2004 20:05:42 +1200 From: Mark Kirkwood Subject: Re: PITR COPY Failure (was Point in Time Recovery) In-reply-to: <40FA1D29.1040100@coretech.co.nz> Cc: Simon Riggs , pgsql-hackers@postgresql.org Message-id: <40FA2F56.3080306@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> <40FA1D29.1040100@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/937 X-Sequence-Number: 56498 fixed. Mark Kirkwood wrote: > 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) >> >