Tom Lane wrote:
> Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)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.
In response to
pgsql-bugs by date
|Next:||From: Heikki Linnakangas||Date: 2009-09-10 09:44:27|
|Subject: Re: BUG #5038: WAL file is pending deletion in pg_xlog folder,
this interferes with WAL archiving.|
|Previous:||From: Robert Haas||Date: 2009-09-10 01:18:50|
|Subject: Re: need higher extra_float_digits value (3)|