| From: | Einar Karttunen <ekarttun(at)cs(dot)Helsinki(dot)FI> |
|---|---|
| To: | "Joshua b(dot) Jore" <josh(at)kitten(dot)greentechnologist(dot)org> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: undo delete w/ transaction? |
| Date: | 2001-10-25 12:47:01 |
| Message-ID: | 20011025154701.A24565@cs.helsinki.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Per Aronsson | 2001-10-25 14:04:00 | UNICODE |
| Previous Message | Joshua b. Jore | 2001-10-25 12:11:39 | undo delete w/ transaction? |