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 8A5EC52C15 for ; Mon, 1 Aug 2005 16:43:55 -0300 (ADT) 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 02147-01 for ; Mon, 1 Aug 2005 19:43:49 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id B508452B81 for ; Mon, 1 Aug 2005 16:43:47 -0300 (ADT) Received: from [192.168.1.55] (fc1smp [66.93.38.87]) (authenticated bits=0) by hosting.commandprompt.com (8.13.4/8.13.4) with ESMTP id j71JhJkD030536; Mon, 1 Aug 2005 12:43:19 -0700 Message-ID: <42EE7BA7.6030005@commandprompt.com> Date: Mon, 01 Aug 2005 12:44:39 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla Thunderbird 1.0.6-1.1.fc4 (X11/20050720) X-Accept-Language: en-us, en MIME-Version: 1.0 To: FM Cc: Mailing List Postgres-Admin Subject: Re: some databases have not been vacuumed ... References: <42EE798A.5040305@lexum.umontreal.ca> In-Reply-To: <42EE798A.5040305@lexum.umontreal.ca> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.014 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200508/9 X-Sequence-Number: 18328 FM wrote: > Hello after a vacuum full analyse I received this : > WARNING: some databases have not been vacuumed in 1805294030 transactions > HINT: Better vacuum them within 342189617 transactions, or you may have > a wraparound failure. > > I read that it's because i do not vacuum DB very often. > Now I vacuum every night but the warning remains. > How can I get rid of this ? Run a vacuum full on all the database. > > Thanks ! > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240 PostgreSQL Replication, Consulting, Custom Programming, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/