| From: | Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com> |
|---|---|
| To: | Dhandapani Shanmugam <postgresql95(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL Active-Active |
| Date: | 2018-02-06 11:38:56 |
| Message-ID: | CAGDYbUNKf4b4Ahpfh0pF18W0cjmzj_ehnvN1R-noQPMxQqWnwg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
You can achieve this HA with forward and backward reverse synchronous
streaming replication with 3 nodes automatic failover with pgpool in
PostgreSQL.
There is always downtime but it should not be more than a minute its
depends on your hardware and network bandwidth speed availability.
--
[image: http://www.shreeyansh.com] <http://www.shreeyansh.com/>
On Tue, Feb 6, 2018 at 4:31 PM, Dhandapani Shanmugam <postgresql95(at)gmail(dot)com
> wrote:
> Hi Gurus,
>
> 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.
>
> -D
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | marcos sr | 2018-02-06 18:09:06 | ERROR: 42501: must be member of role "*" |
| Previous Message | Thomas Kellerer | 2018-02-06 11:30:19 | Re: PostgreSQL Active-Active |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2018-02-06 12:31:20 | Re: Pgcrypto (PostgreSQL 10) on Debain 9? |
| Previous Message | Thomas Kellerer | 2018-02-06 11:30:19 | Re: PostgreSQL Active-Active |