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 25BA09FA6B1 for ; Thu, 24 Aug 2006 11:43:30 -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 78804-05 for ; Thu, 24 Aug 2006 14:43:13 +0000 (UTC) X-Greylist: delayed 00:31:34.437871 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B0DC79FB306 for ; Thu, 24 Aug 2006 11:43:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail.livedatagroup.com (mail.livedatagroup.com [64.139.134.201]) by svr4.postgresql.org (Postfix) with ESMTP id CD52D5AF03F for ; Thu, 24 Aug 2006 14:11:36 +0000 (GMT) Received: by mail.livedatagroup.com (Postfix, from userid 10003) id B40BD23CE60; Thu, 24 Aug 2006 10:11:34 -0400 (EDT) Received: from [192.168.2.134] (adsl-074-228-048-194.sip.bct.bellsouth.net [74.228.48.194]) by mail.livedatagroup.com (Postfix) with ESMTP id 6980023D2A6 for ; Thu, 24 Aug 2006 10:11:32 -0400 (EDT) Message-ID: <44EDB393.2080101@livedatagroup.com> Date: Thu, 24 Aug 2006 10:11:31 -0400 From: Pallav Kalva User-Agent: Thunderbird 1.5.0.5 (X11/20060725) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: 7.4 PG_CLOG problems Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.816 tagged_above=0 required=5 tests=SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: *** X-Archive-Number: 200608/268 X-Sequence-Number: 22811 Hi, Does anybody know what this means ? "LOG: removing file "/var/lib/pgsql/data/pg_clog/0000", There were whole bunch of files got removed from the pg_clog directory. I saw this on my postgres 7.4 log while doing a vacuum on a database last night, this database was never vacuumed before for past one year. The reason we didnt do any vacuum's before on this because it was used only for SELECTS. Is this a problem something to worry about ? my database seems to working fine , I could run all my queries and everything seems to be fine. Thanks! Pallav.