Rollback DELETE command using backup + WAL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux