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. I'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. On Tue, Jan 24, 2012 at 3:32 PM, Jason Couture <plaguethenet@gmail.com>wrote:
Could someone walk me through building a 3 machine postgres cluster with automatic fail over? I've searched and searched and I'm just not getting it.
I currently have postgres 9.1 installed with 1 database as 9.1/main. I'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)
Can anyone help me out?
_______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug