Re: New trigger option of pg_standby

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: New trigger option of pg_standby
Дата
Msg-id 49DDEE72.6030803@enterprisedb.com
обсуждение исходный текст
Ответ на Re: New trigger option of pg_standby  (Fujii Masao <masao.fujii@gmail.com>)
Ответы Re: New trigger option of pg_standby  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
Fujii Masao wrote:
> Hi,
> 
> On Wed, Apr 8, 2009 at 6:56 AM, Guillaume Smet <guillaume.smet@gmail.com> wrote:
>> On Fri, Apr 3, 2009 at 5:42 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
>>> Here is the patch;
>>> - Smart failover is chosen if the trigger file labeled "smart" or
>>>  an empty one exists.
>>> - Fast failover is chosen if the trigger file labeled "fast" exists,
>>>  the signal (SIGUSR1 or SIGINT) is received or the wait timeout
>>>  happens.
>> After some further thoughts, +1 for this approach too.
>>
>> I think you imply 'containing "smart"' not 'labeled "smart"'.
>> "Labeled" is confusing IMHO.
> 
> Thanks for the comment!
> I corrected such confusing expression.

> +     if (strspn(buf, "smart") == 5 && strncmp(buf, "smart", 5) == 0)
> +     {

The strspn() call seems pointless here.

One problem with this patch is that in smart mode, the trigger file is 
not deleted. That's different from current pg_standby behavior, and 
makes accidental failovers after one failover more likely.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Translation conventions
Следующее
От: Sam Mason
Дата:
Сообщение: Re: NaN support in NUMERIC data type