Re: Failed archive_command copy - number of attempts configurable?

Поиск
Список
Период
Сортировка
От Daniel Harris
Тема Re: Failed archive_command copy - number of attempts configurable?
Дата
Msg-id 11DE3EEC54A8A44EAD99D8C0D3FD7207A3487566DA@ENFIMBOX1.ad.datcon.co.uk
обсуждение исходный текст
Ответ на Re: Failed archive_command copy - number of attempts configurable?  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-general
Fujii, thank you very much for this clarification.

Regards,
Dan

-----Original Message-----
From: Fujii Masao [mailto:masao.fujii@gmail.com]
Sent: 09 November 2010 11:55
To: Daniel Harris
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Failed archive_command copy - number of attempts configurable?

On Tue, Nov 9, 2010 at 4:01 AM, dan.m.harris
<daniel.harris@metaswitch.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: PostgreSQL 8.2.3
Следующее
От: Miguel Vaz
Дата:
Сообщение: PostgreSQL database model creation