<p dir="ltr">There plenty of write conditions that will require a read first. </p>
<div class="gmail_extra"><br><div class="gmail_quote">On Nov 6, 2016 4:13 AM, <<a href="mailto:erdenebat@skysys.mn">erdenebat@skysys.mn</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>I'm testing pgpool-II 3.5.4. While load balancing is turned off, pgpool-II gives a following error:</div><div> </div><blockquote><span style="font-family:courier new,monospace">LOG: pool_read_kind: error message from 1 th kind backend:database "mydb" does not exist</span></blockquote><blockquote><span style="font-family:courier new,monospace">ERROR: unable to read message kind</span></blockquote><blockquote><div><span style="font-family:courier new,monospace">DETAIL: kind does not match between master(53) slot[1] (45)</span></div></blockquote><div> </div><div>backend1 is standby server. I don't understand why pgpool-II tries to read from standby while load balancing is off.</div><div> </div><div>Regards,</div><div>Erdenebat</div><div> </div><div> </div><div>06.11.2016, 19:31, "<a href="mailto:erdenebat@skysys.mn" target="_blank">erdenebat@skysys.mn</a>" <<a href="mailto:erdenebat@skysys.mn" target="_blank">erdenebat@skysys.mn</a>>:</div><blockquote type="cite"><div>I turned off load balancing. But it seems that load balancing is still working.</div><div>On the standby, it gives an error 'database does not exist'.</div><div>I understand that pgpool-II does not access standby while load balancing is off.</div><div> </div><div> </div><div>02.11.2016, 17:57, "<a href="mailto:erdenebat@skysys.mn" target="_blank">erdenebat@skysys.mn</a>" <<a href="mailto:erdenebat@skysys.mn" target="_blank">erdenebat@skysys.mn</a>>:</div><blockquote type="cite"><div>Hello guys,</div><div> </div><div>In <a href="http://www.pgpool.net/mediawiki/index.php/FAQ#It_seems_my_pgpool-II_does_not_do_load_balancing._Why.3F" target="_blank">pgpool-II FAQ</a>, it states that "<span style="background-color:#ffffff;color:#252525;display:inline!important;float:none;font-family:sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:normal;text-align:start;text-transform:none;white-space:normal">SELECT will be load balanced even in a transaction if operated in the master/slave mode".</span></div><div><span style="background-color:#ffffff;color:#252525;display:inline!important;float:none;font-family:sans-serif;font-size:14px;font-style:normal;font-variant-caps:normal;font-variant-ligatures:normal;font-weight:normal;text-align:start;text-transform:none;white-space:normal">Is there any way to do it in reverse? Is there any configuration not to load balance SELECT statement if a transaction is in the master/slave mode?</span><br> </div><div>Thanks in advance,</div><div>Erdenebat Oyungerel</div></blockquote>,<p>______________________________<wbr>_________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a></p></blockquote><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></div>