Disaster recovery: pg_class - Mailing list pgsql-admin

From Enrico
Subject Disaster recovery: pg_class
Date
Msg-id 20061013112929.1cbb7b9e@mypc.ricordatasystem.info
Whole thread Raw
Responses Re: Disaster recovery: pg_class  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
After a system crash, I have this error:

 SELECT * from mytable;
 WARNING:  could not write block 14 of 1663/1743558/1259
 DETAIL:  Multiple failures --- write error may be permanent.
 ERROR:  xlog flush request 4/D43E0A00 is not satisfied --- flushed only to 4/D42700F0
 CONTEXT:  writing block 14 of relation 1663/1743558/1

I searched for 1259 oid, and I found that 1259 links to pg_class table.
Is there any way to restore my pg_class table?

Thanks in advantage.

Enrico

--
If Bill Gates had a penny for everytime Windows crashed,he'd be a multi-billionaire by now .......oh look, he already
is!!!! 
scotty@linuxtime.it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi

pgsql-admin by date:

Previous
From: "Paul Schluck"
Date:
Subject: Multiple Database clusters on 1 server: good practice or not advisable?
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: Multiple Database clusters on 1 server: good practice or not advisable?