OKADA Satoshi <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match