From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Dhandapani Shanmugam <postgresql95(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL Active-Active |
Date: | 2018-02-06 11:24:21 |
Message-ID: | 1517916261.2849.23.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2018-02-06 11:30:19 | Re: PostgreSQL Active-Active |
Previous Message | Samuel Teixeira Santos | 2018-02-06 11:18:18 | Re: Postgres install |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2018-02-06 11:30:19 | Re: PostgreSQL Active-Active |
Previous Message | Samuel Teixeira Santos | 2018-02-06 11:18:18 | Re: Postgres install |