I am new to Postgres and installed postgres 8.3.7 build 1200 Windows 2003 server .
I have implemented PITR with WAL shipping which takes one full backup and an hourly backup of the WAL files through backup scripts.The backup script is just copying the files after pg_switch_xlog().
On Saturday of last week, backups started to fail and following error was throw in the logs:
2009-08-28 23:26:55.357 EDT,5648,LOG: archive command failed with exit code 1
The DB was in an idle state and no activities were being performed on it when the issue appeared.
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 and it looks the problem got resolved,but after an hour when backup script ran again it throws similar error but with different name.
postgresql1.log:2009-08-31 17:41:35.117 EDT,5648,WARNING: transaction log file "000000010000000400000010" could not be archived: too many failures
postgresql1.log:2009-08-31 17:42:37.226 EDT,5648,WARNING: transaction log file "000000010000000400000010" could not be archived: too many failures
All the parameters in postgresql.conf are default.
Can I know the reason as why it is happening and how can I resolve it.
