Re: [GENERAL] 8.1.4 - problem with PITR - .backup.done / backup.ready version of the same file at the same time. - Mailing list pgsql-hackers

"Rafael Martinez, Guerrero" <r.m.guerrero@usit.uio.no> writes:
> The problem was that 000000010000000800000010.0006D5E8.backup was
> already archived, but under pg_xlog/archive_status/ there were two
> files:
> -------------------------------------------------
> 000000010000000800000010.0006D5E8.backup.done
> 000000010000000800000010.0006D5E8.backup.ready
> -------------------------------------------------

> This situation should not happen, anyone has seen this problem before?

No, it shouldn't.  What I suspect is that XLogArchiveIsDone() got
confused and created a duplicate .ready file.  It basically assumes
that the only way its stat() calls can fail is ENOENT, ie, file not
there ... but I wonder if they failed for some other reason instead.
What sort of platform and filesystem is this on?

Did you happen to make note of the mod times of the two files before
deleting them?
        regards, tom lane