Re: Problem with a transaction on dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with a transaction on dump
Дата
Msg-id 21664.1175698278@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problem with a transaction on dump  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Froggy / Froggy Corp. wrote:
>> pg_dump: ERREUR:  Impossible d'acc�der au statut de la transaction
>> 892415538

> What files are there in main/pg_clog?

Doesn't really matter --- I'd say it's pretty obviously a data corruption
problem.  That value equates to 35312e32 hex which looks way too much
like ASCII.  Investigation with pg_filedump might give some clue about
what happened, but if you just want to salvage what you can, the key is
to identify and zero out the broken page.  See past discussions of
recovery from data corruption in the archives.

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Problem with a transaction on dump
Следующее
От: "Froggy / Froggy Corp."
Дата:
Сообщение: Re: Problem with a transaction on dump