On Tue, Sep 05, 2006 at 10:45:40PM -0700, Sriram Dandapani wrote:
> WARNING:  database "xxx" must be vacuumed within 10094646 transactions
> 
>  
> 
> I shutdown, restart pg and issue a vacuumdb -f <database>

-f does _not_ mean "vacuum all databases".  It means "do VACUUM
FULL".  These aren't the same thing.  My bet is what you need is 

vacuumdb -a

You've probably missed a database you don't know is there.

A


-- 
Andrew Sullivan  | [EMAIL PROTECTED]
Everything that happens in the world happens at some place.
                --Jane Jacobs 

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to