Re: PostgreSQL Active-Active

Dhandapani Shanmugam wrote:
> Do we have active-active setup in postgreSQL, like we have in oracle RAC?.
> Sorry if this question has been addressed already.
> What will be best open source HA for postgresql with zero RTO and RPO.

No, PostgreSQL does not have a shared storage cluster technology like RAC,
and I don't think it ever will: too complicated, does not scale well
(cache fusion, global SCN).

The normal way is to use physical replication with some third-party
cluster software that handles the failover.

There is *always* a short down time, but it shouldn't be more than a minute.
If you need to avoid data loss, use synchronous replication, but be aware
that it requires a low latency network, else your write throughput will
be very bad.

Yours,
Laurenz Albe