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 B405A9FA61D for ; Wed, 6 Sep 2006 14:32:14 -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 62037-01-3 for ; Wed, 6 Sep 2006 14:32:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from outbound.mailhop.org (outbound.mailhop.org [63.208.196.171]) by postgresql.org (Postfix) with ESMTP id 5FB7B9FB3EA for ; Wed, 6 Sep 2006 14:25:23 -0300 (ADT) Received: from ool-435121e8.dyn.optonline.net ([67.81.33.232] helo=[192.168.0.96]) by outbound.mailhop.org with esmtpa (Exim 4.51) id 1GL19N-0006fV-Nu; Wed, 06 Sep 2006 13:25:21 -0400 X-Mail-Handler: MailHop Outbound by DynDNS X-Originating-IP: 67.81.33.232 X-Report-Abuse-To: abuse@dyndns.com (see http://www.mailhop.org/outbound/abuse.html for abuse reporting information) X-MHO-User: tocr Message-ID: <44FF049F.8050709@zeut.net> Date: Wed, 06 Sep 2006 13:25:51 -0400 From: Matthew O'Connor User-Agent: Thunderbird 2.0a1 (Windows/20060724) MIME-Version: 1.0 To: Sriram Dandapani CC: Tom Lane , pgsql-admin@postgresql.org Subject: Re: transactoin id wraparound problem References: <6992E470F12A444BB787B5C937B9D4DF05ABC7EA@ca-mail1.cis.local> In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF05ABC7EA@ca-mail1.cis.local> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.042 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS X-Spam-Level: X-Archive-Number: 200609/38 X-Sequence-Number: 22952 A PostgreSQL superuser, so yes user postgres will work just fine. 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) > > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Wednesday, September 06, 2006 6:41 AM > To: Sriram Dandapani > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] transactoin id wraparound problem > > "Sriram Dandapani" writes: >> I get error messages on the console that says >> WARNING: database "xxx" must be vacuumed within 10094646 transactions > >> I shutdown, restart pg and issue a vacuumdb -f > > The shutdown/restart was a waste of typing, and -f doesn't really help > here either. > >> I still get messages saying database must be vacuumed and the >> transaction count keeps decreasing. > > I'll bet a nickel you did not run the vacuum as superuser. It has to be > done by a superuser to have permission to vacuum every table in the > database (including system catalogs). > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster >