Re: Maximum Availability Architecture(MAA) for PostgreSQL

Am 2015-04-08 10:22, schrieb Wei Shan:
> In the PostgreSQL world, what do you guys think would be the
> equivalent?
>
> Attached is a diagram I have thought of. Clusters of pg-pool2 used to
> load balance the connection in and for connection failover when a DB
> crashes. Between master and slave, sync replication is being used for
> zero-data-loss.

Why do you need 3 pg-pool instances? 2 instances uses watchdog should
be sufficient?
And if you plan to use sync replication you need to plan for 3
PostgreSQL Servers (a 3rd one that the sync replication can fail-over
to).

Regards,

Jan