X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 29F1355683 for ; Thu, 10 Mar 2005 15:57:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67247-02 for ; Thu, 10 Mar 2005 15:57:34 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 8079952A66 for ; Thu, 10 Mar 2005 15:57:33 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j2AFvZHo013948 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 10 Mar 2005 08:57:37 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j2AFvYTu086110; Thu, 10 Mar 2005 08:57:34 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j2AFvYDv086109; Thu, 10 Mar 2005 08:57:34 -0700 (MST) (envelope-from mfuhr) Date: Thu, 10 Mar 2005 08:57:34 -0700 From: Michael Fuhr To: "Milen A. Radev" Cc: pgsql-admin@postgresql.org Subject: Re: Too frequent warnings for wraparound failure Message-ID: <20050310155734.GA86004@winnie.fuhr.org> References: <42301107.6010901@securax.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <42301107.6010901@securax.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/150 X-Sequence-Number: 16648 On Thu, Mar 10, 2005 at 11:19:03AM +0200, Milen A. Radev wrote: > exec /usr/local/pgsql/bin/vacuumdb -U postgres -h localhost \ > - --all --analyze >>$PG_VACUUM_LOG 2>&1 My first thought was that the lone hyphen at the beginning of the script's last line might be causing an end of option processing, but your output does show many databases being vacuumed (do all databases appear in the real output?). However, I tried running that script with several versions of PostgreSQL and vacuumdb failed with a usage error in every case. Are you sure the script you posted is the one that's running? What version of PostgreSQL are you using? As Tom mentioned, what's the output of the following query? SELECT datname, age(datfrozenxid) FROM pg_database; -- Michael Fuhr http://www.fuhr.org/~mfuhr/