Re: Recovering data via raw table and field separators

Поиск
Список
Период
Сортировка
От John Wells
Тема Re: Recovering data via raw table and field separators
Дата
Msg-id 44dddf400712061135g5af19cf0nb576ef4d3be39691@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Recovering data via raw table and field separators  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: Recovering data via raw table and field separators
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Nested loop in simple query taking long time
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Continual Postgres headaches...