Re: Failed archive_command copy - number of attempts configurable?

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: "dan(dot)m(dot)harris" <daniel(dot)harris(at)metaswitch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Failed archive_command copy - number of attempts configurable?
Date: 2010-11-09 13:55:14
Message-ID: AANLkTi=CiXuwa4zQu6nxnTbvRyAzyJjTjwK7J5odCZam@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 9, 2010 at 4:01 AM, dan.m.harris
<daniel(dot)harris(at)metaswitch(dot)com> wrote:
> But then the primary retries this another 49 times! So 150 attempts in all.
>
> What I need to know is whether these numbers are configurable?

No.

> Can they be
> timed? How long before the primary stops retrying altogether?

Forever until the archive will have been available again.

BTW, since the primary cannot remove the unarchived WAL file from
pg_xlog directory, unless you fix the archive soon, the primary might
run out of the disk space and cause a PANIC error.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Allan Kamau 2010-11-09 14:04:27 Re: Why facebook used mysql ?
Previous Message Matthieu Huin 2010-11-09 13:38:56 Re: temporary table as a subset of an existing table and indexes