Re: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.
Дата
Msg-id 20161007002143.hnbklrqlhu6uqc77@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.  (厚积薄发 <postgresql_2016@163.com>)
Ответы Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.  (厚积薄发 <postgresql_2016@163.com>)
Список pgsql-bugs
Дерево обсуждения 
On 2016-10-06 17:15:30 -0700, 厚积薄发 wrote:
> I know that. My question is when I use the reload method to change the
> synchronous_commit(from on to off), but the query replication state seems
> not change. Although it is in the async mode, it shows in the sync mode.

Read Michael's mail again. He explains precisely
this. synchronous_standby_names (per cluster) is the relevant bit, not
synchronous_commit (per session).

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

Предыдущее
От: 厚积薄发
Дата:
Сообщение: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.