Re: PITR - Some data is not recovered.

OKADA Satoshi <okada(dot)satoshi(at)lab(dot)ntt(dot)co(dot)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