Re: Postgresql active-active nodes in cluster

Thanks all for your inputs.

*
Currently I'm working on active-passive(Primary and standby scenario).
*
I'm preparing one study report on active-active node implementation which talks about active-active nodes background, theoretical explanation, implementation part which includes some trails on this. For that, I'm checking for the resources.

Thanks
Vidyashree H S
________________________________
From: Bruce Momjian <bruce(at)momjian(dot)us>
Sent: Friday, May 10, 2024 4:53 AM
To: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com>; Vidyashree H S <Shreevidya(dot)hs(at)exaleapsemi(dot)com>; pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgresql active-active nodes in cluster

On Thu, May 9, 2024 at 06:33:39PM -0400, Greg Sabino Mullane wrote:
>
> https://wiki.postgresql.org/wiki/Multimaster
>
>
> That is a pretty old page. There are other solutions, such as pgedge, but the
> three most important questions when it comes to active-active replication are:
>
> * Do you really, really need it? (hint: the answer is no)
> * What problem are you trying to solve?
> * Are you really willing to suffer the tradeoffs?

Agreed, see this:

https://momjian.us/main/blogs/pgblog/2018.html#December_24_2018

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.
[EXT]