Re: master/master replication with load balancer in front

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