Re: Database recovery after fs crash

Поиск
Список
Период
Сортировка
От J.Henning@t-online.de
Тема Re: Database recovery after fs crash
Дата
Msg-id 1925.213.252.135.82.1062080765.squirrel@vds.ath.cx
обсуждение исходный текст
Ответ на Re: Database recovery after fs crash  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
>> How do I do that? I don't know the format of the clog files. The only
>> information I found was in clog.h and xlog.h.
>
> xlog is fairly easy, I think resetxlog or something can work there. For
> clog I just noted from the logs which clog files it was missing and
> created them filled with either 0x00 or 0x55 (I forget if it make a
> difference) and kept going until done.

Thanks a lot for your help. Whatever table I was able to identify I was
able to recover. I just filled every clog file missing with 0x00 and used
pg_resetxlog for the xlog files, just like you suggested. It worked :)
Now, I have at least part of my data back.

  Christian

В списке pgsql-general по дате отправления:

Предыдущее
От: "Ivar"
Дата:
Сообщение: Re: Functions have 32 args limt ???
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: The ..... worm