Rollback DELETE command using backup + WAL - Mailing list pgsql-admin

From Zarko Susnjar
Subject Rollback DELETE command using backup + WAL
Date
Msg-id e3c22d390709181110k25a518d0x5aec235ef39444f8@mail.gmail.com
Whole thread Raw
List 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

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Postgresql Server is not starting during it's installation
Next
From: "Scott Marlowe"
Date:
Subject: Re: Postgresql Server is not starting during it's installation