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

From: Andres Freund <andres(at)anarazel(dot)de>
To: 厚积薄发 <postgresql_2016(at)163(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
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: 2016-10-07 00:21:43
Message-ID: 20161007002143.hnbklrqlhu6uqc77@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2016-10-07 00:22:06 Re: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.
Previous Message 厚积薄发 2016-10-07 00:15:30 Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode.