Re: postgres 8.2.9 transaction id wraparound failure

Maria L. Wilson wrote:
> I was afraid you'd say that - any quick way to vacuum all 315 databases
> on this machine?

Actually you only need to vacuum the database being complained about --
"postgres" in this case.  You can issue
SELECT datname, age(datfrozenxid) FROM pg_database ORDER BY age(datfrozenxid) DESC
to find whether any other database is going to need vacuuming as well.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.