Re: PITR, checkpoint, and local relations

"J. R. Nield" <jrnield@usol.com> writes:
> The xlog code must allow us to force an advance to the next log file,
> and truncate the archived file when it's copied so as not to waste
> space.

Uh, why?  Why not just force a checkpoint and remember the exact
location of the checkpoint within the current log file?

When and if you roll back to a prior checkpoint, you'd want to start the
system running forward with a new xlog file, I think (compare what
pg_resetxlog does).  But it doesn't follow that you MUST force an xlog
file boundary simply because you're taking a backup.

> This complicates both the recovery logic and XLogInsert, and I'm trying
> to kill the "last" latent bug in that feature now.

Indeed.  How about keeping it simple, instead?
        regards, tom lane