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
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? |