Re: Patch: add recovery_timeout option to control timeout of restore_command nonzero status code

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Patch: add recovery_timeout option to control timeout of restore_command nonzero status code
Дата
Msg-id 20141104134156.GP28295@alap3.anarazel.de
обсуждение исходный текст
Ответ на Patch: add recovery_timeout option to control timeout of restore_command nonzero status code  (Alexey Vasiliev <leopard_ne@inbox.ru>)
Ответы Re[2]: [HACKERS] Patch: add recovery_timeout option to control timeout of restore_command nonzero status code  (Alexey Vasiliev <leopard_ne@inbox.ru>)
Список pgsql-hackers
Hi,

On 2014-11-03 14:04:00 +0300, Alexey Vasiliev wrote:
> *  What the patch does in a short paragraph: This patch should add option recovery_timeout, which help to control
timeoutof restore_command nonzero status code. Right now default value is 5 seconds. This is useful, if I using for
restoreof wal logs some external storage (like AWS S3) and no matter what the slave database will lag behind the
master.The problem, what for each request to AWS S3 need to pay, what is why for N nodes, which try to get next wal log
each5 seconds will be bigger price, than for example each 30 seconds. Before I do this in this way: " if !
(/usr/local/bin/envdir/etc/wal-e.d/env /usr/local/bin/wal-e wal-fetch "%f" "%p"); then sleep 60; fi ". But in this case
restart/stopdatabase slower.
 

Without saying that the feature is unneccessary, wouldn't this better be
solved by using streaming rep most of the time?

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: What exactly is our CRC algorithm?
Следующее
От: "ktm@rice.edu"
Дата:
Сообщение: Re: Let's drop two obsolete features which are bear-traps for novices