Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.

Tom Lane wrote:
> Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
>> No, it's a backend that's holding the file open, with FILE_SHARE_DELETE.
>
> If that's the only case we care about covering, then rename might be
> enough.  I was just wondering what it would take to solve the more
> general problem of something holding it open with the wrong flags
> at the time we want to get rid of it.

Yes, that's a separate problem, and I think we should address that too.
That's what I thought was going on in OP's case at first, the patch I
posted in my first reply should address that.

I'll try to reproduce that case too, and verify that the patch fixes it.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com