Safe to delete archived log files generated by ongoing transaction?

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

 



Hi,

I have a long running transaction (> 24 hours) running on a development machine and so far it's generated more than 50 gigs of log files which are being archived to another disk. That disk is starting to run low and I'm wondering if deleting these logs will affect the ongoing transaction at all? I.e. does a commit or a rollback require access to the original transaction logs?

The postgresql instance is version 9.2, the base backup was generated using the pg_basebackup utility with the "--xlog" parameter so if necessary I should also be able to recover without the use of those log files, correct?

--
Mitchell Bosecke, B.Sc.
Software Developer

FORCORP
#101, 11710 Kingsway NW
Edmonton , AB, T5G 0X5
www.forcorp.com

(o) 780.452.5878 ext. 263
(f) 780.453.3986

[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