Re: Postgresql HA Cluster

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(dot)albe(at)cybertec(dot)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
>
>