X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 053C39FA236 for ; Wed, 6 Sep 2006 09:15:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 20300-10 for ; Wed, 6 Sep 2006 12:15:48 +0000 (UTC) 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 891F79FB2A9 for ; Wed, 6 Sep 2006 09:15:26 -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 1GKwYD-00004v-E4 for pgsql-admin@postgresql.org; Wed, 06 Sep 2006 08:30:41 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 2A8274172; Wed, 6 Sep 2006 08:15:20 -0400 (EDT) Date: Wed, 6 Sep 2006 08:15:20 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: transactoin id wraparound problem Message-ID: <20060906121520.GD31856@phlogiston.dyndns.org> References: <6992E470F12A444BB787B5C937B9D4DF05ABC7C8@ca-mail1.cis.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF05ABC7C8@ca-mail1.cis.local> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/34 X-Sequence-Number: 22948 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 -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