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

Поиск
Список
Период
Сортировка
От Tomas J Stehlik
Тема Is it possible to recover the schema from the raw files?
Дата
Msg-id 000001d19d7d$7bf6f4f0$73e4ded0$@stehlik.co.uk
обсуждение исходный текст
Ответы Re: Is it possible to recover the schema from the raw files?  (Venkata Balaji N <nag1010@gmail.com>)
Список pgsql-general
Hello,

There was a corruption to the file system due to sudden shutdown of Windows
7.

The attempt to connect to one of the databases results in multiple errors,
like the following one:
ERROR:  invalid page in block 58 of relation base/161326/233745

Several raw files were completely lost (zeroed), thus utterly disabling the
functionality of this particural database.

The raw files were backed up separately outside of the original data folder
upon discovery of the issue.

I would like to ask whether it is possible to recover the database schema
from the raw files?
The data itself is less important in this case.

Thank you in advance for any insight into such a topic.

Kind regards,

Tomas



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

Предыдущее
От: Manuel Gómez
Дата:
Сообщение: Re: Proper relational database?
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Proper relational database?