Re: Standbys, txid_current_snapshot, wraparound - Mailing list pgsql-hackers

From Daniel Farina
Subject Re: Standbys, txid_current_snapshot, wraparound
Date
Msg-id CAAZKuFYGt4yDe97e2hNNCFjXW44Dnq+i7w6JfGhyBVB7KJ3iQw@mail.gmail.com
Whole thread Raw
In response to Re: Standbys, txid_current_snapshot, wraparound  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
On Fri, Mar 23, 2012 at 1:52 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> So we have this?
>
> Master pg_controldata - OK txid_current_snapshot() - OK
> Standby pg_controldata - OK txid_current_snapshot() - lower value
>
> Are there just 2 standbys? So all standbys have acted identically?

Yes, I believe this is the situation. All have acted identically.
Also, some new data:

I took a new base backup after the epoch increment and started a new
standby, and it reported txid_current_snapshot correctly, at least
moments after it became consistent.  This morning, however, it does
not, and reports the 0-epoch number.

-- 
fdr


pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Reporting WAL file containing checkpoint's REDO record in pg_controldata's result
Next
From: Greg Stark
Date:
Subject: Re: query cache