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 <postgresq...@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 >
