Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL Active-Active - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: PostgreSQL Active-Active
Date
Msg-id CAGDYbUNKf4b4Ahpfh0pF18W0cjmzj_ehnvN1R-noQPMxQqWnwg@mail.gmail.com
Whole thread Raw
In response to PostgreSQL Active-Active  (Dhandapani Shanmugam <postgresql95@gmail.com>)
List pgsql-admin
Tree view
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.

-- 
http://www.shreeyansh.com


On Tue, Feb 6, 2018 at 4:31 PM, Dhandapani Shanmugam <postgresql95@gmail.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


​

pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: PostgreSQL Active-Active
Next
From: marcos sr
Date:
Subject: ERROR: 42501: must be member of role "*"