Re: Recovering data via raw table and field separators

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?