Re: Specific questions about wraparound and vacuum

"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