<div dir="ltr">Thank you Tatsuo that's great to hear!</div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Jun 13, 2015 at 11:05 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">> How does load balancing interact with transactions? We have a gui<br>
> application that does inserts and updates followed immediately by a select<br>
> to render the results... How do we ensure those selects always go to the<br>
> master?<br>
<br>
</div></div>Assuming that you are using streaming replication mode, you can start<br>
an explicit transaction and within the transaction you issue an<br>
insert/update then issue a select to render the result. This way, the<br>
select after the insert/update is always redirected to master.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div><br></div>