| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Marko Kreen <markokr(at)gmail(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-28 21:54:58 |
| Message-ID: | CA+U5nMJW=4KGSfj2ai8GsQ5YP-qRHMMhMTEM2m17boLSMTNtpg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Mar 28, 2012 at 10:24 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Wed, Mar 28, 2012 at 9:48 PM, Marko Kreen <markokr(at)gmail(dot)com> wrote:
>> On Fri, Mar 23, 2012 at 08:52:40AM +0000, Simon Riggs wrote:
>>> Master pg_controldata - OK txid_current_snapshot() - OK
>>> Standby pg_controldata - OK txid_current_snapshot() - lower value
>>
>> On Skytools list is report about master with slaves, but the
>> lower value appears on master too:
>>
>> http://lists.pgfoundry.org/pipermail/skytools-users/2012-March/001601.html
>>
>> Cc'd original reporter too.
>
> Thanks. Am looking.
I can't see how this could happen on the master at all.
On the standby, it can happen if we skip restartpoints for about a
couple of billion xids. Which would be a problem.
More on this tomorrow.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2012-03-28 22:31:31 | Re: BUG #6522: PostgreSQL does not start |
| Previous Message | Robert Haas | 2012-03-28 21:31:15 | Re: Finer Extension dependencies |