Skip site navigation (1) Skip section navigation (2)

Re: Standbys, txid_current_snapshot, wraparound

From: Marko Kreen <markokr(at)gmail(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Daniel Farina <daniel(at)heroku(dot)com>,pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>,Andrey Velikoredchanin <uncleandyv(at)gmail(dot)com>
Subject: Re: Standbys, txid_current_snapshot, wraparound
Date: 2012-03-29 14:29:37
Message-ID: 20120329142937.GA9947@gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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(at)gmail(dot)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


In response to

pgsql-hackers by date

Next:From: Dobes VandermeerDate: 2012-03-29 14:37:08
Subject: HTTP Frontend? (and a brief thought on materialized views)
Previous:From: Simon RiggsDate: 2012-03-29 14:23:01
Subject: Re: Standbys, txid_current_snapshot, wraparound

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group