| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Anna Kanevsky <akanevsky(at)aahe(dot)org> |
| Cc: | "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Delete accident |
| Date: | 2003-10-02 23:43:00 |
| Message-ID: | 20031002164129.B76566@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anna Kanevsky | 2003-10-02 23:44:54 | Re: Delete accident |
| Previous Message | Chris White (cjwhite) | 2003-10-02 23:40:08 | Re: Question about DB VACUUM |