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 | ajs@xxxxxxxxxxxxxxx Everything that happens in the world happens at some place. --Jane Jacobs