Re: How to Recover From Accidental Deletes ?

From: "Anthony I Raj" <anthony_raj(at)persistent(dot)co(dot)in>
To: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>
Cc: anthony_raj(at)persistent(dot)co(dot)in, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: How to Recover From Accidental Deletes ?
Date: 2004-02-24 03:35:31
Message-ID: 1327.219.65.83.17.1077593731.squirrel@webmail.persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> 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

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Hiroshi Saito 2004-02-24 16:12:26 Re: Solaris9 Sparc64 edition
Previous Message Anthony Raj 2004-02-23 21:56:07 How to Recover From Accidental Deletes ?