[pgpool-general: 5764] pgpool 3.6 failover with slave lag

Алексей beznebeev at gmail.com
Sun Oct 8 02:33:53 JST 2017


Example:
Have 2 servers with stream replication: master and slave
Slave lag time we can see by sql on slave:
SELECT now() - pg_last_xact_replay_timestamp() AS time_lag;

pgpool can check time_lag by sr_check mechanism and use for load balance
query.
But can it disable failover on slave, on which time_lag exceed pointed
value or if stream replication fails?

Alexey
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20171007/9b55b2e0/attachment.html>


More information about the pgpool-general mailing list