> I see there are many different ways to build a PG cluster. What would be > the best choice in my case? Hi, a few keywords in your mail hint at the fact you're using AWS? If that's the case, you might want to look into their managed PostgreSQL hosting: it's called Amazon RDS for PostgreSQL and supports failover ("Multi AZ") and master-slave replication ("Read Replicas"). There's no master-master support, though. If you need that, you might want to look into BDR, but then you need to patch... As load balancer, PgPool-II might be what you're looking for. Bye, Chris. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general