Re: Postgresql active-active nodes in cluster

[Vidyashree H S <Shreevidya.hs@xxxxxxxxxxxxxxx>]

Hi,

• Is that multi master replication is not recommended to do ?
• If we can do, can I get any resource for implementing that on PostgreSQL which is open-source?

Thanks,

Vidyshree H S

---

From: Vidyashree H S <Shreevidya.hs@xxxxxxxxxxxxxxx>
Sent: Friday, May 10, 2024 10:48 AM
To: Bruce Momjian <bruce@xxxxxxxxxx>; Greg Sabino Mullane <htamfids@xxxxxxxxx>
Cc: Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
Subject: 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@xxxxxxxxxx>
Sent: Friday, May 10, 2024 4:53 AM
To: Greg Sabino Mullane <htamfids@xxxxxxxxx>
Cc: Kashif Zeeshan <kashi.zeeshan@xxxxxxxxx>; Vidyashree H S <Shreevidya.hs@xxxxxxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxxx>        https://momjian.us
  EDB                                      https://enterprisedb.com

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