Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation" - Mailing list pgsql-admin

From Tom Lane
Subject Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
Date
Msg-id 14240.1271448147@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"  (Alexandre Leclerc <aleclerc@ipso.ca>)
List pgsql-admin
Alexandre Leclerc <aleclerc@ipso.ca> writes:
> I'm always getting:
> WARNING: db "template1" must be vacuumed within 999593 transactions
> HINT: To avoid... execute a full-database VACUUM in "template1"
> ... (repeated many times until 999568)

Yeah, I think you will get that bleat once per table processed, until
you've resolved the problem (which will likely take vacuuming each
database in the installation).  Don't sweat it.

            regards, tom lane

pgsql-admin by date:

Previous
From: Alexandre Leclerc
Date:
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"
Next
From: robin
Date:
Subject: Re: Vacuum Full (PG 8.1) - Urgent help needed - Cancel & transaction "liberation"