Re: Is it possible to recover the schema from the raw files?

Поиск
Список
Период
Сортировка
От Tomas J Stehlik
Тема Re: Is it possible to recover the schema from the raw files?
Дата
Msg-id 003901d19e44$142419d0$3c6c4d70$@stehlik.co.uk
обсуждение исходный текст
Ответ на Re: Is it possible to recover the schema from the raw files?  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
Hello Karsten,

Thank you.

> Like replacing (some of) the pg_* containing raw files with
 > those from an uncorrupted database (having been suggested
 > earlier this year) which may work if the corrupted blocks in
 > pg_* only affect data actually describing _that_ database
 > rather than establishing relationships not unique to this
 > database (say, encodings, default operators, ...). If those
 > can be replaced and there is still corruption in some parts
 > describing the local schema then it may work to apply
 > zero_damaged_pages, pg_resetxlog, and similar tools in order
 > to make some of the schema dumpable.

This is actually a very interesting idea.

Kind regards,

Tomas



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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Is it possible to recover the schema from the raw files?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Is it possible to recover the schema from the raw files?