X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7BF469FB35F for ; Wed, 6 Sep 2006 14:37:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 63058-01-4 for ; Wed, 6 Sep 2006 14:37:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 2E00E9FB361 for ; Wed, 6 Sep 2006 14:33:37 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1GL1WA-0003Ia-Cn for pgsql-admin@postgresql.org; Wed, 06 Sep 2006 13:48:54 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 70C2C3FAF; Wed, 6 Sep 2006 13:33:31 -0400 (EDT) Date: Wed, 6 Sep 2006 13:33:31 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: transactoin id wraparound problem Message-ID: <20060906173331.GH362@phlogiston.dyndns.org> References: <6992E470F12A444BB787B5C937B9D4DF05ABC81A@ca-mail1.cis.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF05ABC81A@ca-mail1.cis.local> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.199 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/41 X-Sequence-Number: 22955 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