[BUGS] BUG #6291: Xid epoch is not updated properly

2011-11-13 Thread Daniel Farina
The following bug has been logged online: Bug reference: 6291 Logged by: Daniel Farina Email address: dan...@heroku.com PostgreSQL version: 9.0.5 Operating system: Ubuntu 10.04 Description:Xid epoch is not updated properly Details: We have on hand a database that

Re: [BUGS] BUG #6291: Xid epoch is not updated properly

2011-11-13 Thread Tom Lane
Daniel Farina dan...@heroku.com writes: We have on hand a database that makes heavy use of the txid_snapshot family of functions, and recently it just passed its 4^32 transaction mark. Unfortunately, upon wraparound the xid epoch appears to not have been incremented, remaining at 0. I failed

Re: [BUGS] BUG #4335: Error w/ PostgreSQL EnterpriseDB Stack Builder

2011-11-13 Thread Robert Haas
On Sat, Nov 12, 2011 at 8:10 AM, alextc alex.tao.c...@gmail.com wrote: I am new to PostgreSQL. I have recently PostgreSQL 9.1 and App Stack Builder 3.0.0. The same error occurred to my home computer running Vista. Has this Bug been fixed? Thanks I seriously doubt that this is broken for

Re: [BUGS] BUG #6291: Xid epoch is not updated properly

2011-11-13 Thread Daniel Farina
On Sun, Nov 13, 2011 at 3:27 PM, Tom Lane t...@sss.pgh.pa.us wrote: Daniel Farina dan...@heroku.com writes: We have on hand a database that makes heavy use of the txid_snapshot family of functions, and recently it just passed its 4^32 transaction mark. Unfortunately, upon wraparound the xid