Hi,<br /><br />I am new to Postgres and installed postgres 8.3.7 build 1200 Windows 2003 server .<br /><br />I have
implementedPITR with WAL shipping which takes one full backup and an hourly backup of the WAL files through backup
scripts.Thebackup script is just copying the files after pg_switch_xlog().<br /><br />On Saturday of last week, backups
startedto fail and following error was throw in the logs:<br /><br />2009-08-28 23:26:55.357 EDT,5648,LOG: archive
commandfailed with exit code 1<br /><br />2009-08-28 23:26:55.357 EDT,5648,DETAIL: The failed archive command was:
call"E:\Entrust\Security Manager\bin\ARCHWAL.BAT" "pg_xlog\0000000100000003000000E2"<br /><br /><b>The DB was in an
idlestate and no activities were being performed on it when the issue appeared. </b><br /><br />Later on with some
analysis,I checked there was a file with same name in archive_status directory but with .ready, so I renamed that file
andit looks the problem got resolved,but after an hour when backup script ran again it throws similar error but with
differentname. <br /><br />postgresql1.log:2009-08-31 17:41:35.117 EDT,5648,WARNING: transaction log file
"000000010000000400000010"could not be archived: too many failures<br /><br />postgresql1.log:2009-08-31 17:42:37.226
EDT,5648,WARNING: transaction log file "000000010000000400000010" could not be archived: too many failures<br /><br
/><br/>All the parameters in postgresql.conf are default.<br /><br />Can I know the reason as why it is happening and
howcan I resolve it.<br /><br />Regards<br />Abhishek<br /><br /><br /><br /><br />