Safe to delete archived log files generated by ongoing transaction? - Mailing list pgsql-admin

From Mitchell Bösecke
Subject Safe to delete archived log files generated by ongoing transaction?
Date
Msg-id CACT-PvKq552jWzqhPDUE6rJSv_N24fgTw5rnjQCLPZfZUiM_2w@mail.gmail.com
Whole thread Raw
Responses Re: Safe to delete archived log files generated by ongoing transaction?
List pgsql-admin
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

(o) 780.452.5878 ext. 263
(f) 780.453.3986

pgsql-admin by date:

Previous
From: jayknowsunix@gmail.com
Date:
Subject: Re: When is it safe to remove recovery.done?
Next
From: Albe Laurenz
Date:
Subject: Re: Safe to delete archived log files generated by ongoing transaction?