Re: Recovering data via raw table and field separators - Mailing list pgsql-general

From John Wells
Subject Re: Recovering data via raw table and field separators
Date
Msg-id 44dddf400712061135g5af19cf0nb576ef4d3be39691@mail.gmail.com
Whole thread Raw
In response to Re: Recovering data via raw table and field separators  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Recovering data via raw table and field separators
List pgsql-general
On 12/5/07, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> Not that I know of.
>
> I think the simplest thing to get your tuples back is:
>
> 1. mark the transaction that deleted them as aborted in pg_clog
> 2. reset the hint bits in the deleted tuples, or hack your postgres copy
> to ignore hint bits
>
> You can figure out the transaction that deleted the tuples by seeing
> that their Xmax value is with pg_filedump.
>
> The hint bits part makes it rather messy :-(

A bit beyond me I'm afriad, at least at my current level with
postgresql. Does anyone offer a commercial tool to do this? Or, would
anyone be interested in doing it for a fee?

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Nested loop in simple query taking long time
Next
From: "Merlin Moncure"
Date:
Subject: Re: Continual Postgres headaches...