Safe to delete archived log files generated by ongoing transaction?

Поиск
Список
Период
Сортировка
От Mitchell Bösecke
Тема Safe to delete archived log files generated by ongoing transaction?
Дата
Msg-id CACT-PvKq552jWzqhPDUE6rJSv_N24fgTw5rnjQCLPZfZUiM_2w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Safe to delete archived log files generated by ongoing transaction?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Список 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 по дате отправления:

Предыдущее
От: jayknowsunix@gmail.com
Дата:
Сообщение: Re: When is it safe to remove recovery.done?
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Safe to delete archived log files generated by ongoing transaction?