<div dir="ltr"><div><div>The most I've ever had to do was replication. I used the set up from the postgres docs here:<br><a href="http://www.postgresql.org/docs/9.2/static/warm-standby.html#STREAMING-REPLICATION">http://www.postgresql.org/docs/9.2/static/warm-standby.html#STREAMING-REPLICATION</a><br>
<br></div>Load balancing a write service is far more challenging. If it's read-only, then do it at the upstream application layer.<br><br></div>I never had the opportunity to try it but a cascading replication with the top as ONLY the write server and all the rest as read-only servers. This requires logic at the application level and some network load balancing but not much.<br>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Mar 24, 2014 at 4:42 PM, Preston <span dir="ltr"><<a href="mailto:preston.lists@gmail.com" target="_blank">preston.lists@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<font face="DejaVu Sans">Hey folks, what are you doing for some kind
of load balancing with PostgreSQL</font>? How do you handle live
migration with PostgreSQL?<br>
<br>
thoughts? pointers?<span class="HOEnZb"><font color="#888888"><br>
<br>
Preston<br>
<pre cols="72">--
Be who you are and say what you feel, because those who mind don’t matter and those who matter don’t mind.
-Dr. Seuss
</pre>
</font></span></div>
<br>_______________________________________________<br>
Ale mailing list<br>
<a href="mailto:Ale@ale.org">Ale@ale.org</a><br>
<a href="http://mail.ale.org/mailman/listinfo/ale" target="_blank">http://mail.ale.org/mailman/listinfo/ale</a><br>
See JOBS, ANNOUNCE and SCHOOLS lists at<br>
<a href="http://mail.ale.org/mailman/listinfo" target="_blank">http://mail.ale.org/mailman/listinfo</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr">-- <br>James P. Kinney III<br><i><i><i><i><br></i></i></i></i>Every time you stop a school, you will have to build a jail. What you
gain at one end you lose at the other. It's like feeding a dog on his
own tail. It won't fatten the dog.<br>
- Speech 11/23/1900 Mark Twain<br><i><i><i><i><br><a href="http://heretothereideas.blogspot.com/" target="_blank">http://heretothereideas.blogspot.com/</a><br></i></i></i></i></div>
</div>