Re: pg_receivewal documentation

Поиск
Список
Период
Сортировка
От Jesper Pedersen
Тема Re: pg_receivewal documentation
Дата
Msg-id 9fea76ce-6912-c262-6f64-2b7c4496be65@redhat.com
обсуждение исходный текст
Ответ на Re: pg_receivewal documentation  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: pg_receivewal documentation  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Hi,

On 7/21/19 9:48 PM, Michael Paquier wrote:
>> Since pg_receivewal does not apply WAL, you should not allow it to
>> become a synchronous standby when synchronous_commit = remote_apply.
>> If it does, it will appear to be a standby which never catches up,
>> which may cause commits to block.  To avoid this, you should either
>> configure an appropriate value for synchronous_standby_names, or
>> specify an application_name for pg_receivewal that does not match it,
>> or change the value of synchronous_commit to something other than
>> remote_apply.
>>
>> I think that'd be a lot more useful than enumerating the total-failure
>> scenarios.
> 
> +1.  Thanks for the suggestions!  Your wording looks good to me.

+1

Here is the patch for it, with Robert as the author.

Best regards,
  Jesper


Вложения

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

Предыдущее
От: Jesper Pedersen
Дата:
Сообщение: Re: Index Skip Scan
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: POC: converting Lists into arrays