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 17:33:31
Message-ID: 20060906173331.GH362@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, Sep 06, 2006 at 09:48:45AM -0700, Sriram Dandapani wrote:
> Is there a quick way(other than vacuum full) to re-init the transaction
> ids. (I can afford some downtime)

You don't need a vacuum full. You just need a bog-standard vacuum,
but you need it _on every database_.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
The fact that technology doesn't work is no bar to success in the marketplace.
--Philip Greenspun

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2006-09-06 17:34:40 Re: transactoin id wraparound problem
Previous Message Andrew Sullivan 2006-09-06 17:31:02 Re: transactoin id wraparound problem