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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Luke Koops <luke(dot)koops(at)entrust(dot)com>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(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-09 19:20:21
Message-ID: 5386.1252524021@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Luke Koops <luke(dot)koops(at)entrust(dot)com> writes:
> Heikki is proposing that the file be renamed before it is first deleted.

Indeed, and what I'm saying is that that will still fail if some
unhelpful program is holding the file open without FILE_SHARE_DELETE.
Which is what I understood your case to be ...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Luke Koops 2009-09-09 19:27:04 Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.
Previous Message Luke Koops 2009-09-09 19:11:09 Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.