Safe to delete archived log files generated by ongoing transaction?

From: Mitchell Bösecke <mitchell(dot)bosecke(at)forcorp(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Safe to delete archived log files generated by ongoing transaction?
Date: 2014-07-23 13:36:51
Message-ID: CACT-PvKq552jWzqhPDUE6rJSv_N24fgTw5rnjQCLPZfZUiM_2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
www.forcorp.com

(o) 780.452.5878 ext. 263
(f) 780.453.3986

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2014-07-23 13:54:13 Re: Safe to delete archived log files generated by ongoing transaction?
Previous Message Rural Hunter 2014-07-23 13:21:00 Very slow planning performance on partition table