Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group