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 017EAD1B289 for ; Wed, 30 Jun 2004 12:59:37 -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 48634-01 for ; Wed, 30 Jun 2004 15:59:31 +0000 (GMT) Received: from bluff.diade.it (adsl-161-130.38-151.net24.it [151.38.130.161]) by svr1.postgresql.org (Postfix) with ESMTP id 3FF8ED1B25D for ; Wed, 30 Jun 2004 12:59:29 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by bluff.diade.it (Postfix) with ESMTP id 7FB5AB3D9 for ; Wed, 30 Jun 2004 17:59:23 +0200 (CEST) Received: from bluff.diade.it ([127.0.0.1]) by localhost (bluff [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00926-07 for ; Wed, 30 Jun 2004 17:59:20 +0200 (CEST) Received: by bluff.diade.it (Postfix, from userid 500) id 21A2F1C38B; Wed, 30 Jun 2004 17:59:20 +0200 (CEST) Date: Wed, 30 Jun 2004 17:59:19 +0200 From: Sandro Dentella To: pgsql-admin@postgresql.org Subject: pg_clog error after crash Message-ID: <20040630155919.GA3174@bluff> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.6+20040523i X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at e-den.it X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/23 X-Sequence-Number: 14091 After a crash of the (frozen) system, postgreSQL issues a message: 2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia 2004-06-30 17:51:39 [3165] ERROR: could not access status of transaction 4011600129 DETAIL: could not open file "/var/lib/postgres/data/pg_clog/0EF1": No such file or directory when trying to acces a db. I'm really clueless as I didn't find anything usefull with google to fix it. The db is very little, and I'm the only one that writes on it, so I know there shouldn't be real problems ignoring the transaction, but I don't know what to say postgreSQL to ingore it. Should I recreate an empty file? TYA sandro *:-) PS: can you cc to me too, I'm not on this list. Thanks -- Sandro Dentella *:-) e-mail: sandro@e-den.it http://www.tksql.org TkSQL Home page - My GPL work