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 18B919FB39F for ; Wed, 6 Sep 2006 14:36:21 -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 99400-02-3 for ; Wed, 6 Sep 2006 17:36:18 +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 9DEA69FB3AE for ; Wed, 6 Sep 2006 14:31:11 -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 1GL1Tn-0003H9-WF for pgsql-admin@postgresql.org; Wed, 06 Sep 2006 13:46:28 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 06BAB3FAF; Wed, 6 Sep 2006 13:31:02 -0400 (EDT) Date: Wed, 6 Sep 2006 13:31:02 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: transactoin id wraparound problem Message-ID: <20060906173101.GG362@phlogiston.dyndns.org> References: <6992E470F12A444BB787B5C937B9D4DF05ABC7EA@ca-mail1.cis.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF05ABC7EA@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/40 X-Sequence-Number: 22954 On Wed, Sep 06, 2006 at 06:53:28AM -0700, Sriram Dandapani wrote: > Do you mean that I login as say root and issue a vacuumdb (or do I login > as a postgres user with special privileges) Probably you want vacuumdb -U postgres -a The -a tells it to do all databases, and the -U postgres tells it to connect as the postgresql superuser. If your superuser is something other than postgres (sometimes it is -- pgsql for instance -- but rarely), you should use that username instead. This is the _database_ user name, not the UNIX username (which is what root would be). You'll need the (postgresql) password for the account in question to do this. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland