| From: | "Zarko Susnjar" <zharcos(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Rollback DELETE command using backup + WAL |
| Date: | 2007-09-18 18:10:24 |
| Message-ID: | e3c22d390709181110k25a518d0x5aec235ef39444f8@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
I'm using PGSQL version 8.0
"Accidentally" I deleted around 40000 (it's exactly 44242) rows from one
table. Last backup (.sql) I made is 1 month old and probably only around
30000 records are there. After deleting records immediately I made a copy of
pgsql/data directory and i see that probably all of 10000 records I miss are
there ( 6 files from 0000000100000012000000C0 to 0000000100000012000000C6).
Is there any possible way to extract needed records from WAL files and in
combination with backup script restore all data which has been deleted?
Thanks in advance,
Zarko
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Elharar, Oded | 2007-09-19 08:31:54 | Problem installing postgreSQL on windows VM. |
| Previous Message | Scott Marlowe | 2007-09-18 16:18:06 | Re: Postgresql Server is not starting during it's installation |