Обсуждение: Active Active PostgreSQL Solution
Hello Everyone,
I have been working on PostgreSQL databases for the last three years and I have also migrate databases from Oracle to PostgreSQL as well. I configured PostgreSQL for logical replication as well.
Now in order to deploy PostgreSQL in our production servers, I need to configure it in Active Active mode. Can anyone help me to do so?
Thanks in advance.
----------
Best Regards
Mohsin
Mohsin
On 9 June 2023 12:38:40 CEST, Mohsin Kazmi <shahmohsin46@gmail.com> wrote: >Hello Everyone, > >I have been working on PostgreSQL databases for the last three years and I >have also migrate databases from Oracle to PostgreSQL as well. I configured >PostgreSQL for logical replication as well. > >Now in order to deploy PostgreSQL in our production servers, I need to >configure it in Active Active mode. Can anyone help me to do so? > You can ask EDB, we have a solution, but it is not for free and not open source. Andreas
Postgres 16 will have origin on logical replication, so you can have Active Active mode.
regards,
Marcos
Em sex., 9 de jun. de 2023 às 07:41, Mohsin Kazmi <shahmohsin46@gmail.com> escreveu:
Hello Everyone,I have been working on PostgreSQL databases for the last three years and I have also migrate databases from Oracle to PostgreSQL as well. I configured PostgreSQL for logical replication as well.Now in order to deploy PostgreSQL in our production servers, I need to configure it in Active Active mode. Can anyone help me to do so?Thanks in advance.----------Best Regards
Mohsin
Mohsin Kazmi wrote on 6/9/23 3:38 AM:
We don't need multi-master postgres very often, but when we do, we find the open source bucardo project works fairly well for us. It's a little clunky but its ability to allow for arbitrary functions to handle write conflicts is nice.
Now in order to deploy PostgreSQL in our production servers, I need to configure it in Active Active mode. Can anyone help me to do so?
We don't need multi-master postgres very often, but when we do, we find the open source bucardo project works fairly well for us. It's a little clunky but its ability to allow for arbitrary functions to handle write conflicts is nice.
On Fri, Jun 9, 2023 at 10:01:48AM -0300, Marcos Pegoraro wrote: > Postgres 16 will have origin on logical replication, so you can have Active > Active mode. Uh, I have no idea what that means and I didn't think we had active-active in PG 16. -- Bruce Momjian <bruce@momjian.us> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.
Em sex., 9 de jun. de 2023 às 22:22, Bruce Momjian
Uh, I have no idea what that means and I didn't think we had active-active in version 16
Atenciosamente,
On Sat, Jun 10, 2023 at 02:18:18AM -0300, Marcos Pegoraro wrote: > > > Em sex., 9 de jun. de 2023 às 22:22, Bruce Momjian > > > Uh, I have no idea what that means and I didn't think we had active-active > in version 16 > > https://postgrespro.com/blog/pgsql/5969859#commit_36628396 Oh, that's very interesting, thanks. -- Bruce Momjian <bruce@momjian.us> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.
On 6/9/23 06:38, Mohsin Kazmi wrote: > Hello Everyone, > > I have been working on PostgreSQL databases for the last three years and > I have also migrate databases from Oracle to PostgreSQL as well. I > configured PostgreSQL for logical replication as well. > > Now in order to deploy PostgreSQL in our production servers, I need to > configure it in Active Active mode. Can anyone help me to do so? pgEdge is working on a solution for active-active. It is not yet GA so not ready for production. It will be available for free. https://www.pgedge.com/ Best Regards, Jan