Re: pg_archivecleanup should remove WAL files also in pg_xlog?

On Mon, Dec 13, 2010 at 3:44 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> 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?

Well, we can avoid this problem by specifying pg_xlog directory instead of
the archive in recovery_end_command:

recovery_end_command = 'pg_archivecleanup pg_xlog %r'

Though this sounds like somewhat bad know-how..

Regards,

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