Active Active PostgreSQL Solution

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:

Mohsin Kazmi wrote on 6/9/23 3:38 AM:

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

https://postgrespro.com/blog/pgsql/5969859#commit_36628396

Regards
Marcos
--

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