[pgpool-general: 5601] Re: <External>Re: Unused status problem
Birnbaum, Warren (ETW)
Warren.Birnbaum at nike.com
Thu Jun 29 03:26:04 JST 2017
Thanks Tatsuo Ishii,
This worked perfectly.
Warren
On 28/06/2017, 02:41, "Tatsuo Ishii" <ishii at sraoss.co.jp> wrote:
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