<div dir="ltr">Hi<br><div class="gmail_extra"><br><div class="gmail_quote">2018-04-05 12:28 GMT+02:00 Mathias Buresch <span dir="ltr"><<a href="mailto:mathias.buresch@de.clara.net" target="_blank">mathias.buresch@de.clara.net</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="DE">
<div class="gmail-m_-5314830047676094383WordSection1">
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt">Hi there,<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt">maybe someone can help me to understand how “Streaming Replication Check” is working.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt">Is it checking replication lag by using pg_last_xlog_receive_location(<wbr>) and pg_last_xlog_replay_location() ??</span></p></div></div></blockquote><div class="gmail_quote"><br></div><div class="gmail_quote">check_replication_time_lag function call those functions<br></div><a href="https://github.com/mbell8903/pgpool-II/blob/master/src/streaming_replication/pool_worker_child.c#L230">https://github.com/mbell8903/pgpool-II/blob/master/src/streaming_replication/pool_worker_child.c#L230</a><br><a href="https://github.com/mbell8903/pgpool-II/blob/master/src/streaming_replication/pool_worker_child.c#L289-L295">https://github.com/mbell8903/pgpool-II/blob/master/src/streaming_replication/pool_worker_child.c#L289-L295</a><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="DE"><div class="gmail-m_-5314830047676094383WordSection1"><p class="MsoNormal"><span lang="EN-US" style="font-size:11pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt">Am I right that those check should not be dependent from database I use?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt">If it is like that why I need “sr_check_database”?</span></p></div></div></blockquote><div><br></div><div>this is the convention of postgresql connection requiered but it will use postgres as default.</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="DE"><div class="gmail-m_-5314830047676094383WordSection1"><p class="MsoNormal"><span lang="EN-US" style="font-size:11pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt">Also why “delay_threshold” cannot be 0? Why 0 is disabling it?<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt">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?!</span><span lang="EN-US" style="font-size:11pt"><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11pt"><u></u> </span></p></div></div></blockquote><div>In my opinion your standby node was async when your customer tried to read previous inserted data on master node. Did you try to set delay_threshold ?</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="DE"><div class="gmail-m_-5314830047676094383WordSection1"><p class="MsoNormal"><span lang="EN-US" style="font-size:11pt"><u></u></span></p>
<p class="MsoNormal"><span style="font-size:9pt;font-family:Arial,sans-serif;color:black">Mit herzlichen Grüßen<br>
<br>
Mathias Buresch<br>
Systems Engineer<br>
-- <br>
<a href="mailto:mathias.buresch@de.clara.net" target="_blank">mathias.buresch@de.clara.net</a><br>
Tel: +49 (69) 40 80 18 - 265<br>
Fax: +49 (69) 40 80 18 - 129<br>
<br>
Claranet GmbH<br>
Hanauer Landstraße 196<br>
60314 Frankfurt<br>
<br>
Geschäftsführung Olaf Fischer<br>
Hrb 50381 AG Frankfurt am Main<br>
Vat-ID de 812918694<br>
<br>
<a href="http://www.claranet.de" target="_blank">http://www.claranet.de</a></span><span style="font-size:11pt"><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div></div>