Re: Active Active PostgreSQL Solution

2023-06-14 Thread Jan Wieck
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

Re: Active Active PostgreSQL Solution

2023-06-10 Thread Bruce Momjian
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

Re: Active Active PostgreSQL Solution

2023-06-09 Thread Marcos Pegoraro
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,

Re: Active Active PostgreSQL Solution

2023-06-09 Thread Bruce Momjian
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 https://momjian.us EDB

Re: Active Active PostgreSQL Solution

2023-06-09 Thread Ben Chobot
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

Re: Active Active PostgreSQL Solution

2023-06-09 Thread Marcos Pegoraro
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 escreveu: > Hello Everyone, > > I have been working on PostgreSQL databases for the last three years and I > have also migrate databases

Re: Active Active PostgreSQL Solution

2023-06-09 Thread Andreas Kretschmer
On 9 June 2023 12:38:40 CEST, 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

Active Active PostgreSQL Solution

2023-06-09 Thread Mohsin Kazmi
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