Re: Database Recovery

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Database Recovery
Дата
Msg-id 26143.1191808096@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Database Recovery  ("Mike C" <smith.not.western@gmail.com>)
Ответы Re: Database Recovery
Список pgsql-admin
"Mike C" <smith.not.western@gmail.com> writes:
> I have a corrupt database. I copied the database directory offsite and
> restored from a backup. I'm now trying to recover data in the corrupt
> database added since the last backup. Any advice on how to approach
> this?

If you're lucky, REINDEX might solve your problems.  The messages you
showed are all about index corruption, which REINDEX can fix.  If you've
got corruption in the tables themselves then you might be screwed, but
try reindexing and see what happens ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Warm/hot backup server question
Следующее
От: "Mike C"
Дата:
Сообщение: Re: Database Recovery