Skip site navigation (1)
Skip section navigation (2)
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
Peripheral Links
Header And Logo
|
Site Navigation
Rollback DELETE command using backup + WAL
- From: "Zarko Susnjar" <zharcos(at)gmail(dot)com>
- To: pgsql-admin(at)postgresql(dot)org
- Subject: Rollback DELETE command using backup + WAL
- Date: Tue, 18 Sep 2007 20:10:24 +0200
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
- Prev by Date: Re: Postgresql Server is not starting during it's installation
- Next by Date: Problem installing postgreSQL on windows VM.
- Previous by thread: Postgresql Server is not starting during it's installation
- Next by thread: Problem installing postgreSQL on windows VM.
- Indexes: