"Matthew T. O'Connor" <[EMAIL PROTECTED]> writes: >> On Monday 04 August 2008 11:04:00 pm Robert Shaw wrote: >>> "WARNING: database "mydb" must be vacuumed within 177009986 transactions >>> HINT: To avoid a database shutdown, execute a full-database VACUUM in >>> "mydb".
> BTW, what version of PostgreSQL is this? Database-wide vacuum is no > longer required for XID wraparound issues. I think this was an 8.3 > change but might have happened in 8.2, I don't remember. 8.2. But you could still get that message, even in CVS HEAD, if autovacuum was failing to complete for some reason (and had been failing for quite a long time). regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general