Hi Albe, Here is my one more concern regarding patroni and repmgr tool versions compatibility with centos8 and postgresql 10/11/12 versions, could u plz provide ur valuable output.
Thanks Brajendra On Mon, 29 Jun, 2020, 1:03 PM Laurenz Albe, <laurenz.a...@cybertec.at> wrote: > 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 > >
