"Nick Fankhauser" <nickf@doxpop.com> writes:
> One other question- when I'm vacuuming, I always get the warning:
> WARNING: some databases have not been vacuumed in <big number> transactions
> HINT: Better vacuum them within <big number> transactions, or you may
> have a wraparound failure.
> I get these even after all DBs except template0 have been freshly vacuumed. Why?
Do your vacuums change the pg_database.datfrozenxid values for the
databases? The only reason I can think of for them not to do so
is if you're not doing them as superuser ...
regards, tom lane