Thread: How to Recover From Accidental Deletes ?

Hi ,

I have been trying to look at ways to recover from any accidental deletes.
Reading some pevious posts , its clear that its possible since the
records are
just marked for delete and not actually deleted. Its deleted only after
a Vacuum
command is run .

I believe its possible to talk to backent and read the data in the form
of raw
tuples . Any one know how its done ? or any docs that talk about such
stuff.

In case this is posted in the wrong forum , kindly excuse the same .

thanks in advance,
Anthony

Anthony Raj wrote:

> Hi ,
>
> I have been trying to look at ways to recover from any accidental
> deletes.
> Reading some pevious posts , its clear that its possible since the
> records are
> just marked for delete and not actually deleted. Its deleted only
> after a Vacuum
> command is run .
>
> I believe its possible to talk to backent and read the data in the
> form of raw
> tuples . Any one know how its done ? or any docs that talk about such
> stuff.
>
> In case this is posted in the wrong forum , kindly excuse the same .

This IS the wrong forum, still I'd like to know that too. If interesting
and viable, we could add such a feature to pgadmin3.

Regards,
Andreas

> Anthony Raj wrote:
>
>> Hi ,
>>
>> I have been trying to look at ways to recover from any accidental
>> deletes.
>> Reading some pevious posts , its clear that its possible since the
>> records are
>> just marked for delete and not actually deleted. Its deleted only
>> after a Vacuum
>> command is run .
>>
>> I believe its possible to talk to backent and read the data in the
>> form of raw
>> tuples . Any one know how its done ? or any docs that talk about such
>> stuff.
>>
>> In case this is posted in the wrong forum , kindly excuse the same .
>
> This IS the wrong forum, still I'd like to know that too. If interesting
> and viable, we could add such a feature to pgadmin3.
>
> Regards,
> Andreas
>
>
I've been trying some experiments with talking to backent but , some how I
seem to be in the wrong track . Looking at postgres code carefully looks
like the correct starting point.

Would definitely post the results of this soon.

thanks,
Anthony