PITR WAL Archive error on idle database

Поиск
Список
Период
Сортировка
Искать
От
abhishekgautam009@gmail.com
Тема
PITR WAL Archive error on idle database
Дата
Msg-id
d0e8fd680909011713p6fc9c760g188c07d4a054bc3b@mail.gmail.com
Ответ на
PITR WAL Archive error on idle database (abhishekgautam009@gmail.com)
Список
Дерево обсуждения
PITR WAL Archive error on idle database abhishekgautam009@gmail.com
PITR WAL Archive error on idle database abhishekgautam009@gmail.com

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





В списке pgadmin-support по дате отправления
От: Guillaume Lelarge
Дата:
Сообщение: Re: pgAdmin III Plugins Help
От: Raymond O'Donnell
Дата:
Сообщение: pgAdmin & One-Click Installer
FAQ