Re: Recovering data via raw table and field separators

From: "John Wells" <jb(at)sourceillustrated(dot)com>
To: "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Recovering data via raw table and field separators
Date: 2007-12-06 19:35:42
Message-ID: 44dddf400712061135g5af19cf0nb576ef4d3be39691@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/5/07, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-12-06 19:42:39 Re: Continual Postgres headaches...
Previous Message Alvaro Herrera 2007-12-06 19:26:28 Re: Nested loop in simple query taking long time