pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marcus Whitney <marcus@coldfeetcreative.com>
To: pgsql-performance@postgresql.org
Subject: Re: Failed System.  Help.
Date: Mon, 14 Jun 2004 22:33:26 -0500
Message-ID: <200406142233.26374.marcus@coldfeetcreative.com> (raw)

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



Message-ID: <200406142233.26374.marcus@coldfeetcreative.com>
Permalink:  ../200406142233.26374.marcus@coldfeetcreative.com/
Also on:    postgresql.org/message-id/200406142233.26374.marcus@coldfeetcreative.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: marcus@coldfeetcreative.com
  Subject: Re: Failed System.  Help.
  In-Reply-To: <200406142233.26374.marcus@coldfeetcreative.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox