Skip site navigation (1) Skip section navigation (2)

PITR WAL Archive error on idle database

From: abhishekgautam009(at)gmail(dot)com
To: pgadmin-support(at)postgresql(dot)org
Subject: PITR WAL Archive error on idle database
Date: 2009-09-02 00:13:41
Message-ID: d0e8fd680909011713p6fc9c760g188c07d4a054bc3b@mail.gmail.com (view raw or flat)
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
>
>
>
>
>

In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2009-09-02 08:50:51
Subject: Re: Savepoints in PgAdmin
Previous:From: abhishekgautam009Date: 2009-09-01 23:58:54
Subject: PITR WAL Archive error on idle database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group