[pgpool-general: 6022] Streaming Replication Check
Mathias Buresch
mathias.buresch at de.clara.net
Thu Apr 5 19:28:04 JST 2018
Hi there,
maybe someone can help me to understand how “Streaming Replication Check” is working.
Is it checking replication lag by using pg_last_xlog_receive_location() and pg_last_xlog_replay_location() ??
Am I right that those check should not be dependent from database I use?
If it is like that why I need “sr_check_database”?
Also why “delay_threshold” cannot be 0? Why 0 is disabling it?
The reason I ask is that a customer has problem with inserting something and “directly” read the insert and don’t get the correct answer – maybe because it is not synced and loadbalancing is forwarding to slave?!
Mit herzlichen Grüßen
Mathias Buresch
Systems Engineer
--
mathias.buresch at de.clara.net
Tel: +49 (69) 40 80 18 - 265
Fax: +49 (69) 40 80 18 - 129
Claranet GmbH
Hanauer Landstraße 196
60314 Frankfurt
Geschäftsführung Olaf Fischer
Hrb 50381 AG Frankfurt am Main
Vat-ID de 812918694
http://www.claranet.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20180405/652fc26d/attachment.htm>
More information about the pgpool-general
mailing list