[pgpool-general: 5600] Re: <External>Re: Unused status problem

Tatsuo Ishii ishii at sraoss.co.jp
Wed Jun 28 09:41:33 JST 2017


If the only reason for this mode is to implement synchronous
replication then note that with streaming replication it is also
possible in recent versions of postgres
(https://www.postgresql.org/docs/9.4/static/runtime-config-replication.html#GUC-SYNCHRONOUS-STANDBY-NAMES)

No. If you want a similar effect of Pgpool-II's native replication,
you must set synchronous_commit to 'remote_apply', which is available
in 9.6 or later.

Otherwise you may not see the modified data on standby right after a
transaction commit.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-general mailing list