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

Re: undo delete w/ transaction?

From: "Joshua b(dot) Jore" <josh(at)greentechnologist(dot)org>
To: Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: undo delete w/ transaction?
Date: 2001-10-25 15:15:12
Message-ID: Pine.BSO.4.33.0110251013370.1778-100000@kitten.greentechnologist.org (view raw or flat)
Thread:
Lists: pgsql-novice
Ah I see. That's an enlightening web page. I'm going to reconstruct from
backup + application log (yes, I store the exact SQL that does the
modifications)

If I weren't already doing a gazillion things that undelete program would
be a fun one to hack at.

Joshua Jore
Minneapolis Ward 3, precinct 10

On Thu, 25 Oct 2001, Einar Karttunen wrote:

> On Thu, Oct 25, 2001 at 07:11:39AM -0500, Joshua b. Jore wrote:
> > So I did a bad thing and did a bad DELETE command and deleted *all* the
> > records. I also goofed by not doing that in a transaction. Is there any
> > way to undo the change? I stopped the daemon right after I broke it.
> >
> The easiest way is to restore the db from your backups. (You have backups don't you?)
>
> If that is not possible for some weird reason the data is not deleted just
> marked to be deleted. If you did *nothing* to that table it might be possible
> to resque them as described in http://www.geocrawler.com/archives/3/12/2000/7/0/4119316/.
> (Do wal-logs change this in anyway?)
>
> The first thing to do is to take a backup of the database dir. If the log trick fails
> then study the table format use a hex editor, write a tool to do the undelete and
> share it with us.
>
> - Einar Karttunen
>
>


In response to

pgsql-novice by date

Next:From: Josh BerkusDate: 2001-10-25 15:17:14
Subject: Re: Visual Database Design Tools
Previous:From: Per AronssonDate: 2001-10-25 14:04:00
Subject: UNICODE

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