Postgres Pro
Downloads
Home   >   mailing lists

Re: Specific questions about wraparound and vacuum - Mailing list pgsql-admin

From Tom Lane
Subject Re: Specific questions about wraparound and vacuum
Date
Msg-id 11659.1186623487@sss.pgh.pa.us
Whole thread Raw
In response to Re: Specific questions about wraparound and vacuum  ("Nick Fankhauser" <nickf@doxpop.com>)
Responses Re: Specific questions about wraparound and vacuum
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: "Anderson Alves de Albuquerque "
Date:
Subject: Permission ALTER PASSWORD
Next
From: "Nick Fankhauser"
Date:
Subject: Re: Specific questions about wraparound and vacuum