lost data, possible playback?

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

 



Hi!

A user accidentally deleted some results (i.e. tuples in a postgresql database) created this morning.

I have pg_xlog from about 9 o'clock until now. I have a pg_dump from ab out 3 o'clock this morning.

The results where created from about nine o'clock until noon, when the user accidentally removed the results.

Would it be possible to replay the WAL logs and get the results from pg_xlog + the dump? Or from a file system snapshot as of now (five pm) + pg_xlog?

Regards,
Palle


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[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