On Sun, 2020-06-28 at 09:10 +0530, Brajendra Pratap Singh wrote: > Is there any functionality present in postgresql for High Availability > Cluster where we can setup > multiple nodes/instances in READ-WRITE mode for single database so that > incase of one node/instance > failure it will automatically failover the traffic to 2nd node/instance > (without > failure or in less time) ,this is just like oracle RAC concept . > > Here High Availability Cluster means there will be zero downtime incase of > any one node/instance failure.
There is no such functionality built into PostgreSQL. An architecture like Oracle RAC is not ideal for high availability, since the ASM/Tablespace/Segment "file system" is a single point of failure. You can use Solutions like Patroni or repmgr for high availability. That would not provode a multi-master solution, though. There are some commercial solutions for that, but be warned that it would require non-trivial changes to your application. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
