Hello We had a strange problem yesterday in one of our servers using PITR (postgresql 8.1.4). The script used by archive_command is designed to refuse to overwrite any pre-existing archive file. Yesterday this situation happened and it refused to overwrite a file, filling the log file with this error: ------------------------------------------------- LOG: archive command "archive_wal.sh -P pg_xlog/000000010000000800000010.0006D5E8.backup -F 000000010000000800000010.0006D5E8.backup" failed: return code 256 WARNING: transaction log file "000000010000000800000010.0006D5E8.backup" could not be archived: too many failures ------------------------------------------------- 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 ------------------------------------------------- so postgresql tryed to archive this file again after the first time. We deleted the *.backup.ready file and the problem was gone. This situation should not happen, anyone has seen this problem before? Ideas?, tips? to find why this happened. -- Rafael Martinez, <r.m.guerrero@xxxxxxxxxxx> Center for Information Technology Services University of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/
