Re: Point in Time Recovery - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: Point in Time Recovery
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D159@m0114.s-mxs.net
Whole thread Raw
In response to Point in Time Recovery  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Point in Time Recovery  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
> >> Do we need a checkpoint after the archiving
> >> starts but before the backup begins?
>
> > No.
>
> Actually yes.

Sorry, I did incorrectly not connect 'archiving' with the backed up xlogs :-(
So yes, you need one checkpoint after archiving starts. Imho turning on xlog
archiving should issue such a checkpoint just to be sure.

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Point in Time Recovery
Next
From: Andreas Pflug
Date:
Subject: Re: serverlog rotation/functions