Re: transactoin id wraparound problem - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: transactoin id wraparound problem
Date
Msg-id 20060906121520.GD31856@phlogiston.dyndns.org
Whole thread Raw
In response to transactoin id wraparound problem  ("Sriram Dandapani" <sdandapani@counterpane.com>)
List pgsql-admin
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@crankycanuck.ca
Everything that happens in the world happens at some place.
        --Jane Jacobs

pgsql-admin by date:

Previous
From: Niklas Johansson
Date:
Subject: Re: How to check if VACUUM operations are working?
Next
From: Tom Lane
Date:
Subject: Re: transactoin id wraparound problem