Re: transactoin id wraparound problem

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: transactoin id wraparound problem
Date: 2006-09-06 12:15:20
Message-ID: 20060906121520.GD31856@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)ca
Everything that happens in the world happens at some place.
--Jane Jacobs

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-09-06 13:40:41 Re: transactoin id wraparound problem
Previous Message Niklas Johansson 2006-09-06 10:37:34 Re: How to check if VACUUM operations are working?