Re: Problem with a transaction on dump - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with a transaction on dump
Date
Msg-id 21664.1175698278@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with a transaction on dump  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Problem with a transaction on dump
Next
From: "Froggy / Froggy Corp."
Date:
Subject: Re: Problem with a transaction on dump