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 965C6D1B196 for ; Fri, 11 Jun 2004 08:47:50 -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 68781-04 for ; Fri, 11 Jun 2004 11:47:44 +0000 (GMT) Received: from linux012.intern.cityweb.de (linux012.intern.cityweb.de [195.71.215.252]) by svr1.postgresql.org (Postfix) with ESMTP id 8F345D1B19B for ; Fri, 11 Jun 2004 08:46:58 -0300 (ADT) Received: from zahedi.intern.cityweb.de (zahedi.intern.cityweb.de [193.189.226.198]) by linux012.intern.cityweb.de (8.12.8/8.12.8) with ESMTP id i5BBkb9Y029731 for ; Fri, 11 Jun 2004 13:46:41 +0200 From: Andreas Schmitz Reply-To: a.schmitz@cityweb.de Organization: Cityweb Network To: pgsql-admin@postgresql.org Subject: pg_clog after crash Date: Fri, 11 Jun 2004 13:46:36 +0200 User-Agent: KMail/1.5 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200406111346.36948.a.schmitz@cityweb.de> 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: 200406/147 X-Sequence-Number: 13807 Hello *, after a harddisk filling up to a 100% the database crashed. This is the output I get when I try to start the DB again. Is there any chance to get it back running without using a dump ? regards, -Andreas 2004-06-11 13:38:23 [22379] LOG: database system was interrupted while in recovery at 2004-06-11 13:32:44 CEST HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery. 2004-06-11 13:38:23 [22379] LOG: checkpoint record is at 25/FB90EFA4 2004-06-11 13:38:23 [22379] LOG: redo record is at 25/FB90ED88; undo record is at 0/0; shutdown FALSE 2004-06-11 13:38:23 [22379] LOG: next transaction ID: 10185227; next OID: 17088234 2004-06-11 13:38:23 [22379] LOG: database system was not properly shut down; automatic recovery in progress 2004-06-11 13:38:23 [22379] LOG: redo starts at 25/FB90ED88 2004-06-11 13:38:24 [22379] PANIC: could not access status of transaction 10256385 DETAIL: could not read from file "/var/data/pgsql/data/dbs_1/pg_clog/0009" at offset 204800: Success 2004-06-11 13:38:24 [22373] LOG: startup process (PID 22379) was terminated by signal 6 2004-06-11 13:38:24 [22373] LOG: aborting startup due to startup process failure