broken xlog - recovery plan check

Поиск
Список
Период
Сортировка
От Colin Taylor
Тема broken xlog - recovery plan check
Дата
Msg-id CAN6Zwvtt=q0c2mJtus6DOWGxaaPWQ7u3_f8LNTZfnLD=o_L78Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: broken xlog - recovery plan check  (Thom Brown <thom@linux.com>)
Список pgsql-general
Hi I seem to have an 8.3.9 database with a broken xlog,

PANIC:  heap_insert_redo: invalid max offset number

My plan is to run pg_resetxlog.
Hopefully it then starts up.
Test recent data as thoroughly as possible - (script some Select * ' s?)
If ok -> curse ops and their raid caches
If not -> curse ops and tell them to recover from backup (v. large and
therefore very slow process).

Can anyone give me feedback on this plan?

Cheers
Colin.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Change the default [tgenabled] for new "internal" triggers ?
Следующее
От: Yuanyuan Tian
Дата:
Сообщение: about numerical accuracy of statistical functions