Re: pg_resetxlog bug?

On Fri, 2009-05-01 at 00:07 +0900, Fujii Masao wrote:

> Current pg_resetxlog doesn't remove any archive status files. This
> may cause continuous failure of archive command since .ready file
> remains even if a corresponding XLOG segment is removed. And,
> .done file without XLOG segment cannot be removed by checkpoint,
> and would remain forever. These are undesirable behaviors.

Agreed

> I think that pg_resetxlog should remove existing archive status files
> of XLOG segments. Here is the patch to do so.

Seems OK.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support