Re: Finding time in WAL logs

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

 



On Apr 25, 2007, at 7:01 PM, Simon Riggs wrote:
(this is for a DELETE FROM table without any WHERE clause).  I see
the XID, but can you also display date and time in the ouput ?

Original date/time is available only on COMMIT/ABORT records, so you'll
need to search ahead/behind.

Additionally, you can specify an XID when doing a point-in-time restore; you don't need to find an exact time to restore to.
--
Jim Nasby                                            jim@xxxxxxxxx
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)




[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