pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedActive Active PostgreSQL Solution
8+ messages / 6 participants
[nested] [flat]
* Active Active PostgreSQL Solution
@ 2023-06-09 10:38 Mohsin Kazmi <shahmohsin46@gmail.com>
2023-06-09 12:46 ` Re: Active Active PostgreSQL Solution Andreas Kretschmer <andreas@a-kretschmer.de>
2023-06-09 13:01 ` Re: Active Active PostgreSQL Solution Marcos Pegoraro <marcos@f10.com.br>
2023-06-09 13:04 ` Re: Active Active PostgreSQL Solution Ben Chobot <bench@silentmedia.com>
2023-06-14 16:13 ` Re: Active Active PostgreSQL Solution Jan Wieck <jan@wi3ck.info>
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 10:38 Active Active PostgreSQL Solution Mohsin Kazmi <shahmohsin46@gmail.com>
@ 2023-06-09 12:46 ` Andreas Kretschmer <andreas@a-kretschmer.de>
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 10:38 Active Active PostgreSQL Solution Mohsin Kazmi <shahmohsin46@gmail.com>
@ 2023-06-09 13:01 ` Marcos Pegoraro <marcos@f10.com.br>
2023-06-10 01:22 ` Re: Active Active PostgreSQL Solution Bruce Momjian <bruce@momjian.us>
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 10:38 Active Active PostgreSQL Solution Mohsin Kazmi <shahmohsin46@gmail.com>
2023-06-09 13:01 ` Re: Active Active PostgreSQL Solution Marcos Pegoraro <marcos@f10.com.br>
@ 2023-06-10 01:22 ` Bruce Momjian <bruce@momjian.us>
2023-06-10 05:18 ` Re: Active Active PostgreSQL Solution 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-09 10:38 Active Active PostgreSQL Solution Mohsin Kazmi <shahmohsin46@gmail.com>
2023-06-09 13:01 ` Re: Active Active PostgreSQL Solution Marcos Pegoraro <marcos@f10.com.br>
2023-06-10 01:22 ` Re: Active Active PostgreSQL Solution Bruce Momjian <bruce@momjian.us>
@ 2023-06-10 05:18 ` Marcos Pegoraro <marcos@f10.com.br>
2023-06-10 13:10 ` Re: Active Active PostgreSQL Solution 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-09 10:38 Active Active PostgreSQL Solution Mohsin Kazmi <shahmohsin46@gmail.com>
2023-06-09 13:01 ` Re: Active Active PostgreSQL Solution Marcos Pegoraro <marcos@f10.com.br>
2023-06-10 01:22 ` Re: Active Active PostgreSQL Solution Bruce Momjian <bruce@momjian.us>
2023-06-10 05:18 ` Re: Active Active PostgreSQL Solution Marcos Pegoraro <marcos@f10.com.br>
@ 2023-06-10 13:10 ` Bruce Momjian <bruce@momjian.us>
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-09 10:38 Active Active PostgreSQL Solution Mohsin Kazmi <shahmohsin46@gmail.com>
@ 2023-06-09 13:04 ` Ben Chobot <bench@silentmedia.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-09 10:38 Active Active PostgreSQL Solution Mohsin Kazmi <shahmohsin46@gmail.com>
@ 2023-06-14 16:13 ` Jan Wieck <jan@wi3ck.info>
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