Re: Database corruption.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Database corruption.
Дата
Msg-id 25510.1170955507@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Database corruption.  (Michael Guerin <guerin@rentec.com>)
Список pgsql-general
Michael Guerin <guerin@rentec.com> writes:
> You're suggesting to zero out the block in the underlying table files,
> or creating the missing pg_clog file and start filling with zero's?

The former.  Making up clog data is unlikely to help --- the bad xmin is
just the first symptom of what's probably more widespread corruption in
the table page.  If you want, once you've identified the page containing
the problem, use "pg_filedump -i -f" to dump out that page and we can
have a look to see just how bad it is.

            regards, tom lane

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

Предыдущее
От: Michael Guerin
Дата:
Сообщение: Re: Database corruption.
Следующее
От: "Brusser, Michael"
Дата:
Сообщение: Re: Database corruption.