Skip site navigation (1) Skip section navigation (2)

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

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Luke Koops <luke(dot)koops(at)entrust(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.
Date: 2009-09-10 05:36:23
Message-ID: 4AA89057.10806@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

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

In response to

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 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 HaasDate: 2009-09-10 01:18:50
Subject: Re: need higher extra_float_digits value (3)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group