pg_archivecleanup should remove WAL files also in pg_xlog?

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_archivecleanup should remove WAL files also in pg_xlog?
Date: 2010-12-13 06:44:13
Message-ID: AANLkTik1skAgmbKNYTg0geV59zYjriC0x46brsGaXncR@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

pg_archivecleanup removes unnecessary WAL files from the archive, but not
from pg_xlog directory. So, after failover, those WAL files might
exist in pg_xlog
and be archived again later. Re-archiving of unnecessary WAL files seems odd
to me. To avoid this problem, how about changing pg_archivecleanup so that
it removes WAL files also in pg_xlog or creates .done file in
archive_status when
removing them from the archive?

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2010-12-13 07:06:26 Re: pg_archivecleanup should remove WAL files also in pg_xlog?
Previous Message Itagaki Takahiro 2010-12-13 06:31:42 Re: SQL/MED - file_fdw