From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Dhandapani Shanmugam <postgresql95@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
To: pgsql-general@postgresql.org
Subject: Re: PostgreSQL Active-Active
Date: Tue, 06 Feb 2018 12:24:21 +0100
Message-ID: <1517916261.2849.23.camel@cybertec.at> (raw)
In-Reply-To: <CAAj4MFGjrtpruHsyw9TjXyWH72B0cfiBDNJpqMLsAUuHc8TGhw@mail.gmail.com>
References: <CAAj4MFGjrtpruHsyw9TjXyWH72B0cfiBDNJpqMLsAUuHc8TGhw@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, postgresql95@gmail.com, pgsql-general@postgresql.org
Subject: Re: PostgreSQL Active-Active
In-Reply-To: <1517916261.2849.23.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox