From: | abhishekgautam009(at)gmail(dot)com |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | PITR WAL Archive error on idle database |
Date: | 2009-09-01 23:58:54 |
Message-ID: | d0e8fd680909011658r22e9921j572edd0684d082a0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi,
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
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"
*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.
Regards
Abhishek
From | Date | Subject | |
---|---|---|---|
Next Message | abhishekgautam009 | 2009-09-02 00:13:41 | PITR WAL Archive error on idle database |
Previous Message | Dave Page | 2009-09-01 12:40:51 | Re: Domain wizard bug |