X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C1ECFD1B54D for ; Tue, 15 Jun 2004 00:39:33 -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 92679-07 for ; Tue, 15 Jun 2004 03:39:28 +0000 (GMT) Received: from ml-hw5.monsterlabs.com (ml-hw5.monsterlabs.com [216.183.105.167]) by svr1.postgresql.org (Postfix) with SMTP id EAC58D1B297 for ; Tue, 15 Jun 2004 00:39:26 -0300 (ADT) Received: (qmail 9627 invoked from network); 15 Jun 2004 03:39:25 -0000 Received: from w080.z064003242.bna-tn.dsl.cnc.net (HELO ?192.168.1.15?) (64.3.242.80) by ml-hw5.monsterlabs.com with SMTP; 15 Jun 2004 03:39:25 -0000 From: Marcus Whitney Reply-To: marcus@coldfeetcreative.com Organization: Coldfeet Creative To: pgsql-performance@postgresql.org Subject: Re: Failed System. Help. Date: Mon, 14 Jun 2004 22:33:26 -0500 User-Agent: KMail/1.6.1 MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200406142233.26374.marcus@coldfeetcreative.com> 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/150 X-Sequence-Number: 7208 Hello all, I have a PostgreSQL instance running on a Dell Poweredge 6450. 4 700Mhz processors, 6 GB of Ram, 2GB Backside, 60GB Raid 10 Server. Today, it crashed hard. At the command line (BASH), all I could get was 'bus fault' . After rebooting, we were unable to mount the partition that PostgreSQL was on. When trying to load one of our remote backup archives (pg_dump) from the last week, they all die at a point, saying: pg_restore: [custom archiver] could not read data block -- expected 4096, got 3870 So, basically, we are running e2fsck very carefully as to not destroy any files, but still try and clean up as many issues as possible. Is there anyway to extract the pure data from those archives in spite of the bad blocks? Also, any other suggestions for the situation are welcome. Thanks. - Marcus