Re: Postgresql active-active nodes in cluster

2024-05-13 Thread Greg Sabino Mullane
On Mon, May 13, 2024 at 2:53 AM Vidyashree H S < shreevidya...@exaleapsemi.com> wrote: > >- Is that multi master replication is not recommended to do ? > > No, it is not recommended, as it has a very, very narrow use case, and comes with a lot of drawbacks. Sure, you COULD configure your car t

Re: Postgresql active-active nodes in cluster

2024-05-13 Thread Vidyashree H S
Momjian ; Greg Sabino Mullane Cc: Kashif Zeeshan ; 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

Re: Postgresql active-active nodes in cluster

2024-05-10 Thread Vidyashree H S
stgresql 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 questio

Re: Postgresql active-active nodes in cluster

2024-05-09 Thread Bruce Momjian
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

Re: Postgresql active-active nodes in cluster

2024-05-09 Thread Greg Sabino Mullane
> 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

Re: Postgresql active-active nodes in cluster

2024-05-09 Thread Kashif Zeeshan
Hi You can use BDR, you can have a look on the following link. https://wiki.postgresql.org/wiki/Multimaster Thanks Kashif Zeeshan Bitnine Global On Thu, May 9, 2024 at 3:28 PM Vidyashree H S wrote: > Hi, > > I'm using Postgresql 15.4 version on RISCV architecture > I'm trying to implement act

Postgresql active-active nodes in cluster

2024-05-09 Thread Vidyashree H S
Hi, I'm using Postgresql 15.4 version on RISCV architecture I'm trying to implement active-active nodes in cluster, I have gone through various websites, there they have mentioned the theory concept of it. But I want to implement to verify how active-active nodes actually work. Are there any re