[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