Tom,
If you first delete the file and it goes into deletion pending, then
subsequent attempts to rename or delete will fail.
Heikki is proposing that the file be renamed before it is first deleted.
-Luke
> -----Original Message-----
> From: Tom Lane [mailto:[email protected]]
> Sent: Wednesday, September 09, 2009 3:06 PM
> To: Heikki Linnakangas
> Cc: Luke Koops; [email protected]
> Subject: Re: [BUGS] BUG #5038: WAL file is pending deletion
> in pg_xlog folder, this interferes with WAL archiving.
>
> Heikki Linnakangas <[email protected]> writes:
> > One option is to rename the file before deleting it.
>
> I was under the impression that renaming would fail in the
> same cases where deletion fails, ie something else holding
> the file open ...
>
> regards, tom lane
>
--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
