On Thu, Mar 29, 2012 at 03:23:01PM +0100, Simon Riggs wrote:
> On Thu, Mar 29, 2012 at 3:04 PM, Marko Kreen <markokr@gmail.com> wrote:
> > Next question: how can flipping archive_mode on and off,
> > with restarts, near wraparound point, break epoch on master?
> >
> > http://lists.pgfoundry.org/pipermail/skytools-users/2012-March/001609.html
> >
> > Any ideas?
> >
> > Could WAL playback from backend with different archive_mode setting
> > cause it somehow?
>
> The current code would allow it, if you managed to go for 4 billion
> xids between checkpoints. If that happened, it would give an off by
> one error each time it happened.
>
> I don't believe that is possible.
Yes, that does not sound like probable case.
--
marko