Adrian Klaver wrote:
On Monday 04 August 2008 11:04:00 pm Robert Shaw wrote:
"WARNING: database "mydb" must be vacuumed within 177009986 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
"mydb"."Which is reason I ask the question, is full vacuum backup useful
for anything other than reclaiming disk space.
Actually its not asking for a VACUUM FULL but a VACUUM of the full database,
instead of selected tables.
See below for complete details
http://www.postgresql.org/docs/8.3/interactive/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND
BTW, what version of PostgreSQL is this? Database-wide vacuum is no
longer required for XID wraparound issues. I think this was an 8.3
change but might have happened in 8.2, I don't remember.
Matt
