Re: [GENERAL] Transaction id wraparound problem

2006-11-15 Thread Ed L.
On Wednesday November 15 2006 4:18 pm, Morris Goldstein wrote: > If I'm vacuuming every day (or two), and not running anywhere > near 1 billion transactions a day, why am I running into > transaction id wraparound problems? > Is this just complaining that template0 and template1 haven't > been vac

[GENERAL] Transaction id wraparound problem

2006-11-15 Thread Morris Goldstein
I've encountered transaction wraparound problems in a long-running test using postgresql 7.4.8. There is no critical data at risk, but I do need to understand the problem and get a fix into our product as quickly as possible. My postgres log file has messages like this: 2006-11-14 04:08:19 [2