Thursday, 20 September 2012
postgresql replication, load balancing and SPOFs
here's article for setting up two pgpools - so no single point of failure (thanks to Nozomi Anazai)
here's an article how to set up pgpool to handle replication and load balancing of a postgresql cluster (thanks to Tatsuo Ishii)
And here's a great presentation from Tom Fry @ OrdnanceSurvey on their setup (spatial databases this time) using pgPool. No replication duties in this case I think as it's only handling select duties. Here.