Postgres Pro
Downloads
Home   >   mailing lists

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

From Andres Freund
Subject Re: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.
Date
Msg-id 20161007002143.hnbklrqlhu6uqc77@alap3.anarazel.de
Whole thread Raw
In response to 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>)
Responses Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.
List pgsql-bugs
Tree view 
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 by date:

Previous
From: 厚积薄发
Date:
Subject: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.
Next
From: Michael Paquier
Date:
Subject: Re: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.