Sounds like a good project. I wish I could offer some advice, but I am not familiar with postgres. I hope someone else on this list has some ideas.<br><br>I&#39;ve been meaning to do more things with mysql as it seems to be the gateway dbms and since I used it for a project a few years back.<br>

<br><div class="gmail_quote">On Tue, Jan 24, 2012 at 3:32 PM, Jason Couture <span dir="ltr">&lt;<a href="mailto:plaguethenet@gmail.com">plaguethenet@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">

<p>Could someone walk me through building a 3 machine postgres cluster with automatic fail over? I&#39;ve searched and searched and I&#39;m just not getting it.</p>
<p>I currently have postgres 9.1 installed with 1 database as 9.1/main. I&#39;d like to cluster this to provide ha and faster query times. Writes to the DB can be forced to the master only, so read-only slaves are okay (there are far more reads than writes)</p>



<p>Can anyone help me out?</p>
<br>_______________________________________________<br>
Wlug mailing list<br>
<a href="mailto:Wlug@mail.wlug.org">Wlug@mail.wlug.org</a><br>
<a href="http://mail.wlug.org/mailman/listinfo/wlug" target="_blank">http://mail.wlug.org/mailman/listinfo/wlug</a><br>
<br></blockquote></div><br>