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

[Birnbaum, Warren (ETW)]

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