Re: PITR, checkpoint, and local relations - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PITR, checkpoint, and local relations
Date
Msg-id 29281.1028778077@sss.pgh.pa.us
Whole thread Raw
In response to Re: PITR, checkpoint, and local relations  ("J. R. Nield" <jrnield@usol.com>)
Responses Re: PITR, checkpoint, and local relations  ("J. R. Nield" <jrnield@usol.com>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: Greg Copeland
Date:
Subject: Re: python patch
Next
From: Greg Copeland
Date:
Subject: Another python patch -- minor