Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving. - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.
Date
Msg-id 4AA801B5.4070700@enterprisedb.com
Whole thread Raw
In response to Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
Tom Lane wrote:
> Luke Koops <luke.koops@entrust.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 ...

No, it's a backend that's holding the file open, with FILE_SHARE_DELETE.

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

pgsql-bugs by date:

Previous
From: Luke Koops
Date:
Subject: Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.
Next
From: Tom Lane
Date:
Subject: Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.