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...@exaleapsemi.com> Sent: Friday, May 10, 2024 10:48 AM To: Bruce Momjian <br...@momjian.us>; Greg Sabino Mullane <htamf...@gmail.com> Cc: Kashif Zeeshan <kashi.zees...@gmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org> 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 <br...@momjian.us> Sent: Friday, May 10, 2024 4:53 AM To: Greg Sabino Mullane <htamf...@gmail.com> Cc: Kashif Zeeshan <kashi.zees...@gmail.com>; Vidyashree H S <shreevidya...@exaleapsemi.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.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 <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you. [EXT]
