Re: RE: [ADMIN] SOS !!: Porstgress forgot all ! Help ! - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: RE: [ADMIN] SOS !!: Porstgress forgot all ! Help !
Date
Msg-id 005201c096fd$b79a2a00$4c79583f@sectorbase.com
Whole thread Raw
In response to RE: [ADMIN] SOS !!: Porstgress forgot all ! Help !  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-hackers
> > Ohhhh, your system reached max transaction ID -:(
> 
> That's two reports now of people who have managed to wrap around the XID
> counter.  It doesn't seem that hard to do in a heavily used database.
> 
> Does anyone want to take more seriously the stopgap solution I proposed
> for this problem (pghackers archives around 3-Nov-00)?  I believe you
> shot it down that time, but I don't think that ignoring the problem
> for another release cycle is a better answer.

Actually, I believed that you've done this temp solution till I've found
that it's not true couple weeks ago. If you'll do this please don't forget
about reusing ID of *committed* transactions and crashes - this should
be handled somehow on recovery.

Vadim




pgsql-hackers by date:

Previous
From: "Vadim Mikheev"
Date:
Subject: Re: Open 7.1 items
Next
From: "Vadim Mikheev"
Date:
Subject: Leaving for vacation