Re: Postgresql HA cluster - Mailing list pgsql-general

From Laura Smith
Subject Re: Postgresql HA cluster
Date
Msg-id vpcXDAHFD1W7p676FE7rDkNf1qbvanrr7fAiULGOG0WmbUPQ2ZrlnOxgO7QTG8NB6m9fuGuP8o_Mm-9eduG7xjxeotEM-6KC2d0E9Mzxfk8=@protonmail.ch
Whole thread Raw
In response to Re: Postgresql HA cluster  (Jehan-Guillaume de Rorthais <jgdr@dalibo.com>)
Responses Re: Postgresql HA cluster
List pgsql-general
------- Original Message -------
On Friday, October 13th, 2023 at 14:10, Jehan-Guillaume de Rorthais <jgdr@dalibo.com> wrote:

> But really, double check first why a simple primary-standby architecture doesn't
> meet your needs. The simpler the architecture is, the better. Even from the
> application point of view.
>


From my perspective I do wonder why Postgres doesn't have an equivalent to MySQL Group Replication.

Although you can run MySQL GR as multi-primary, most people run it as primary-standby.

However the difference with Postgres is that MySQL Group does leader election. Whilst Postgres failover/failback is a
highlymanual affair. 



pgsql-general by date:

Previous
From: Lele Gaifax
Date:
Subject: Re: psql \du no more showing "member of" column
Next
From: Pavel Luzanov
Date:
Subject: Re: psql \du no more showing "member of" column