a way to recover the DB of a data/ directory from a corrupted disk?

From: Rocael Hernandez <rocaelh(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: a way to recover the DB of a data/ directory from a corrupted disk?
Date: 2003-07-17 03:23:33
Message-ID: 20030717032333.22345.qmail@web20208.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
my case is quite difficult, I think, so all the help
you can give me is more than welcome!

The short story: I had two disks, the primary running
the database server (pg 7.1.2), the second having the
daily pg_dump's. The first disk started to have I/O
problems, the sencond disk was erased by mystake by my
server provider (arrrg!). So the only thing that I
have right now is a cp that I did from the data/
directory of the disk # 1, the one that were running
the database server I got I/O problems. During the cp,
I got some problems doing it, saying things like I/O
erros and the like (bad blocks), so probably around
20% or so of the files are corrupted or were not
copiead at all.

My question is, what can I do in such a case? =(
Is there a way to recover as much as possible?, how?

Thanks for all your help!
Rocael.

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-07-17 03:34:54 Re: a way to recover the DB of a data/ directory from a corrupted disk?
Previous Message Dan Langille 2003-07-17 02:56:47 Re: Anyone used pgHoster.com?