Re: PITR - Some data is not recovered. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PITR - Some data is not recovered.
Date
Msg-id 16403.1092070750@sss.pgh.pa.us
Whole thread Raw
In response to PITR - Some data is not recovered.  (OKADA Satoshi <okada.satoshi@lab.ntt.co.jp>)
Responses Re: PITR - Some data is not recovered.  (OKADA Satoshi <okada.satoshi@lab.ntt.co.jp>)
List pgsql-hackers
OKADA Satoshi <okada.satoshi@lab.ntt.co.jp> writes:
> I'm testing PITR using pgbench and postgresql ver.8.0bata. 

Is this actually the official beta1 version, or is it a snapshot from
last week sometime?  In the first commit that had pg_start_backup(),
there wasn't any logic to ensure that the recovery replay would really
start from before the backup began.  If a checkpoint occurred after you
started the tar run but before tar got around to copying pg_control,
the recovery wouldn't work properly.  I can't be sure but your report
seems consistent with such a problem.

[ digs in CVS logs ]  The necessary additional code was committed in
revision 1.155 of src/backend/access/transam/xlog.c.  If you have 1.154
please update and try again.  If you do have 1.155 or later then we
need to look closer.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Add Missing From?
Next
From: Stefan Kaltenbrunner
Date:
Subject: Tablespace issues (comment on ,moving indexes)