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

From Andrew Sullivan
Subject Re: transactoin id wraparound problem
Date
Msg-id 20060906173331.GH362@phlogiston.dyndns.org
Whole thread Raw
In response to Re: transactoin id wraparound problem  ("Sriram Dandapani" <sdandapani@counterpane.com>)
List 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@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.
        --Philip Greenspun

pgsql-admin by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: transactoin id wraparound problem
Next
From: Scott Marlowe
Date:
Subject: Re: transactoin id wraparound problem