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. -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
