pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Active Active PostgreSQL Solution
8+ messages / 6 participants
[nested] [flat]

* Active Active PostgreSQL Solution
@ 2023-06-09 10:38  Mohsin Kazmi <shahmohsin46@gmail.com>
  0 siblings, 4 replies; 8+ messages in thread

From: Mohsin Kazmi @ 2023-06-09 10:38 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Active Active PostgreSQL Solution
@ 2023-06-09 12:46  Andreas Kretschmer <andreas@a-kretschmer.de>
  parent: Mohsin Kazmi <shahmohsin46@gmail.com>
  3 siblings, 0 replies; 8+ messages in thread

From: Andreas Kretschmer @ 2023-06-09 12:46 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org, Mohsin Kazmi <shahmohsin46@gmail.com>



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 





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Active Active PostgreSQL Solution
@ 2023-06-09 13:01  Marcos Pegoraro <marcos@f10.com.br>
  parent: Mohsin Kazmi <shahmohsin46@gmail.com>
  3 siblings, 1 reply; 8+ messages in thread

From: Marcos Pegoraro @ 2023-06-09 13:01 UTC (permalink / raw)
  To: Mohsin Kazmi <shahmohsin46@gmail.com>; +Cc: pgsql-general@lists.postgresql.org

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
>

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Active Active PostgreSQL Solution
@ 2023-06-09 13:04  Ben Chobot <bench@silentmedia.com>
  parent: Mohsin Kazmi <shahmohsin46@gmail.com>
  3 siblings, 0 replies; 8+ messages in thread

From: Ben Chobot @ 2023-06-09 13:04 UTC (permalink / raw)
  To: Mohsin Kazmi <shahmohsin46@gmail.com>; +Cc: pgsql-general@lists.postgresql.org

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.

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Active Active PostgreSQL Solution
@ 2023-06-10 01:22  Bruce Momjian <bruce@momjian.us>
  parent: Marcos Pegoraro <marcos@f10.com.br>
  0 siblings, 1 reply; 8+ messages in thread

From: Bruce Momjian @ 2023-06-10 01:22 UTC (permalink / raw)
  To: Marcos Pegoraro <marcos@f10.com.br>; +Cc: Mohsin Kazmi <shahmohsin46@gmail.com>; pgsql-general@lists.postgresql.org

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.





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Active Active PostgreSQL Solution
@ 2023-06-10 05:18  Marcos Pegoraro <marcos@f10.com.br>
  parent: Bruce Momjian <bruce@momjian.us>
  0 siblings, 1 reply; 8+ messages in thread

From: Marcos Pegoraro @ 2023-06-10 05:18 UTC (permalink / raw)
  To: Bruce Momjian <bruce@momjian.us>; +Cc: Mohsin Kazmi <shahmohsin46@gmail.com>; pgsql-general@lists.postgresql.org

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,

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Active Active PostgreSQL Solution
@ 2023-06-10 13:10  Bruce Momjian <bruce@momjian.us>
  parent: Marcos Pegoraro <marcos@f10.com.br>
  0 siblings, 0 replies; 8+ messages in thread

From: Bruce Momjian @ 2023-06-10 13:10 UTC (permalink / raw)
  To: Marcos Pegoraro <marcos@f10.com.br>; +Cc: Mohsin Kazmi <shahmohsin46@gmail.com>; pgsql-general@lists.postgresql.org

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.





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: Active Active PostgreSQL Solution
@ 2023-06-14 16:13  Jan Wieck <jan@wi3ck.info>
  parent: Mohsin Kazmi <shahmohsin46@gmail.com>
  3 siblings, 0 replies; 8+ messages in thread

From: Jan Wieck @ 2023-06-14 16:13 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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






^ permalink  raw  reply  [nested|flat] 8+ messages in thread


end of thread, other threads:[~2023-06-14 16:13 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-06-09 10:38 Active Active PostgreSQL Solution Mohsin Kazmi <shahmohsin46@gmail.com>
2023-06-09 12:46 ` Andreas Kretschmer <andreas@a-kretschmer.de>
2023-06-09 13:01 ` Marcos Pegoraro <marcos@f10.com.br>
2023-06-10 01:22   ` Bruce Momjian <bruce@momjian.us>
2023-06-10 05:18     ` Marcos Pegoraro <marcos@f10.com.br>
2023-06-10 13:10       ` Bruce Momjian <bruce@momjian.us>
2023-06-09 13:04 ` Ben Chobot <bench@silentmedia.com>
2023-06-14 16:13 ` Jan Wieck <jan@wi3ck.info>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox