Disaster recovery: pg_class

From: Enrico <scotty(at)linuxtime(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: Disaster recovery: pg_class
Date: 2006-10-13 09:29:29
Message-ID: 20061013112929.1cbb7b9e@mypc.ricordatasystem.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)linuxtime(dot)it - Skype:sscotty71
http://www.linuxtime.it/enricopirozzi

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gregory S. Williamson 2006-10-13 11:43:09 Re: Multiple Database clusters on 1 server: good practice or not advisable?
Previous Message Paul Schluck 2006-10-13 09:23:47 Multiple Database clusters on 1 server: good practice or not advisable?