Hi,
No guarentees here, but this may help. It can read the postgres backend
files directly and is a bit more robust against errors. It may be able to
recover your data for you. However, it requires that the pg_class and
pg_attribute tables are still intact. It has rescued one persons 7.3 so it
does work, but it hasn't been thoroughly tested.
This isn't the only program either, there are others I just don't know
where (somewhere on Redhat's website?).
http://svana.org/kleptog/pgsql/pgfsck.html
Good luck!
On Wed, Jul 16, 2003 at 08:23:33PM -0700, Rocael Hernandez wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato