Disaster recovery: pg_class

Поиск
Список
Период
Сортировка
От Enrico
Тема Disaster recovery: pg_class
Дата
Msg-id 20061013112929.1cbb7b9e@mypc.ricordatasystem.info
обсуждение исходный текст
Ответы Re: Disaster recovery: pg_class
Список 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 по дате отправления:

Предыдущее
От: "Paul Schluck"
Дата:
Сообщение: Multiple Database clusters on 1 server: good practice or not advisable?
Следующее
От: "Gregory S. Williamson"
Дата:
Сообщение: Re: Multiple Database clusters on 1 server: good practice or not advisable?