> 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.
