<div dir="ltr">We're testing it with your suggested 0 backend weight in the slave. It working fine without load balancing mode.<br><br>We would like to steer clear of the replication lag problems, that reason we're using synchronous replication with remote_write level settings. But I see it is not enough.<br>
<br>Can You suggest us an useful solution?<br><br>Thx,<br>Csaba <br><div class="gmail_extra"><br><br><div class="gmail_quote">2014-04-02 1:15 GMT+02:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</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">Humm.. there's no error messages in the pgpool log. Maybe the<br>
replication lag? To make sure that if that is the cause of the<br>
problem, you could set the slave's backend weight to 0 and restart<br>
pgpool-II.<br>
<div class=""><div class="h5"><br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
</div></div></blockquote></div><br></div></div>