BUG #11517: the pg_stat_replication.sync_stat show sync when synchronous_commit is set to be off

From: amutu(at)amutu(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11517: the pg_stat_replication.sync_stat show sync when synchronous_commit is set to be off
Date: 2014-09-29 07:45:52
Message-ID: 20140929074552.17173.32414@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11517
Logged by: the pg_stat_replication.sync_stat show sync when synchronous_commit is set
to be off
Email address: amutu(at)amutu(dot)com
PostgreSQL version: 9.2.4
Operating system: suse linux 10 x86_64
Description:

from the doc,when synchronous_commit set to off or local,the commit will not
wait the remote slave reveive data,so it is not asynchronous replication.but
I find the pg_stat_replication wrongly report the sync_stat to sync.This can
be confused for people.

postgres=# select * from pg_stat_replication ;
-[ RECORD 1 ]----+------------------------------
pid | 3213
usesysid | 16387
usename | rep
application_name | sync_slave
client_addr | 172.25.38.154
client_hostname |
client_port | 54333
backend_start | 2014-09-29 15:17:19.927457+08
state | streaming
sent_location | 21/A0F01C0
write_location | 21/A0F01C0
flush_location | 21/A0F01C0
replay_location | 21/A0EFC88
sync_priority | 1
sync_state | sync

postgres=# show synchronous_standby_names ;
-[ RECORD 1 ]-------------+-----------------------
synchronous_standby_names | sync_slave,walreceiver

postgres=# show synchronous_commit ;
-[ RECORD 1 ]------+----
synchronous_commit | off

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2014-09-29 07:51:49 Re: BUG #11457: The below query crashes 9.3.5, but not 9.3.4
Previous Message David G Johnston 2014-09-28 02:56:43 Re: BUG #11501: PostgreSQL for Windows (installer) cannot be installed by screen reader users (blind computer users)