[pgpool-general: 4880] Re: Need some explanation about recovery

Tatsuo Ishii ishii at sraoss.co.jp
Sun Aug 7 11:08:58 JST 2016


>> Pgpool-II checks replication delay every sr_check_period second by
>> calling pg_last_xlog_replay_location() on primary and
>> pg_last_xlog_replay_location() on standby, and compares the results.
> 
> Is it a way from a pcp command or other to get this status ?

Oops. "pg_last_xlog_replay_location() on primary" is wrong. It should
be "pg_current_xlog_location() on primary".

Anyway it's pretty easy to write such a script by using psql or some
such.

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