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 DF042D1B7C6 for ; Mon, 14 Jun 2004 05:10:20 -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 31172-10 for ; Mon, 14 Jun 2004 08:10:18 +0000 (GMT) Received: from linux012.intern.cityweb.de (linux012.intern.cityweb.de [195.71.215.252]) by svr1.postgresql.org (Postfix) with ESMTP id F231DD1B7BD for ; Mon, 14 Jun 2004 05:10:14 -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 i5E8AE9Y024812; Mon, 14 Jun 2004 10:10:14 +0200 From: Andreas Schmitz Reply-To: a.schmitz@cityweb.de Organization: Cityweb Network To: Tom Lane Subject: Re: pg_clog after crash Date: Mon, 14 Jun 2004 10:10:13 +0200 User-Agent: KMail/1.5 Cc: pgsql-admin@postgresql.org References: <200406111346.36948.a.schmitz@cityweb.de> <16788.1086976867@sss.pgh.pa.us> In-Reply-To: <16788.1086976867@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200406141010.13376.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/163 X-Sequence-Number: 13823 Hi Tom, PostgreSQL 7.4.1 is used in this case. I was able to fix the clog by dd if=/dev/zero bs=8k count=1 >> Andreas Schmitz writes: > > 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 ? > > What PG version is this? > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- Andreas Schmitz - Phone +49 201 8501 318 Cityweb-Technik-Service-Gesellschaft mbH Friedrichstr. 12 - Fax +49 201 8501 104 45128 Essen - email a.schmitz@cityweb.de