Re: Delete accident - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Delete accident
Date
Msg-id 20031002164129.B76566@megazone.bigpanda.com
Whole thread Raw
In response to Delete accident  (Anna Kanevsky <akanevsky@aahe.org>)
List pgsql-admin
On Tue, 30 Sep 2003, Anna Kanevsky wrote:

> This is an almost embarrassing question, but I managed to delete all rows
> out of one of the tables by making a little typo in the WHERE statement.
> Is there any way to restore these? the db was NOT vacuumed after that. but
> then, it wasn't backed up before either.

Potentially, if vacuum wasn't run, you may be able to go back, find the
transaction that did the delete and mark it as having rolled back, but I
don't really know the details necessary to make that work.

pgsql-admin by date:

Previous
From: "Chris White (cjwhite)"
Date:
Subject: Re: Question about DB VACUUM
Next
From: Gaetano Mendola
Date:
Subject: News group