public inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedHow to setup Multi-master replication on postgresql 18
9+ messages / 7 participants
[nested] [flat]
* How to setup Multi-master replication on postgresql 18
@ 2026-04-06 06:25 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-06 07:09 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
0 siblings, 1 reply; 9+ messages in thread
From: akshay chandratre @ 2026-04-06 06:25 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi Everyone,
The client required the multimaster replication on the production
environment. I want help regarding the following things:
1. How to setup multi-master replication on postgresql ?
2. How to handle the conflicts regarding the writes on both masters
servers ?
3. Is it reliable for production ? Any other suggestions or options for
multimaster ?
Postgresql V18
Os: centOS
Thanks in advance...
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How to setup Multi-master replication on postgresql 18
2026-04-06 06:25 How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
@ 2026-04-06 07:09 ` Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-06 11:44 ` Re: How to setup Multi-master replication on postgresql 18 Mahendra Singh <msmahendrasingh18@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Muhammet Kurtoğlu @ 2026-04-06 07:09 UTC (permalink / raw)
To: akshay chandratre <akshaychandratre44@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi,
You can use symetricds community which resolves conflicts with predefined
rules on master master replication
Best REgards
akshay chandratre <akshaychandratre44@gmail.com>, 6 Nis 2026 Pzt, 09:25
tarihinde şunu yazdı:
> Hi Everyone,
>
> The client required the multimaster replication on the production
> environment. I want help regarding the following things:
> 1. How to setup multi-master replication on postgresql ?
> 2. How to handle the conflicts regarding the writes on both masters
> servers ?
> 3. Is it reliable for production ? Any other suggestions or options for
> multimaster ?
>
> Postgresql V18
> Os: centOS
>
> Thanks in advance...
>
--
*Muhammet KURTOĞLU*
T: +90(312) 220 12 20 <%2B90%28374%29%20262%2098%2000>
F: +90(312) 286 00 10 <%2B90%28374%29%20262%2090%2091>
muhammet.kurtoglu@bisoft.com.tr <caner.olkan@bisoft.com.tr>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How to setup Multi-master replication on postgresql 18
2026-04-06 06:25 How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-06 07:09 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
@ 2026-04-06 11:44 ` Mahendra Singh <msmahendrasingh18@gmail.com>
2026-04-07 07:09 ` Re: How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Mahendra Singh @ 2026-04-06 11:44 UTC (permalink / raw)
To: Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>; +Cc: akshay chandratre <akshaychandratre44@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Dear Akshay,
The answer is *EDB Postgres Distributed.*
On Mon, Apr 6, 2026 at 11:09 AM Muhammet Kurtoğlu <
muhammet.kurtoglu@bisoft.com.tr> wrote:
> Hi,
> You can use symetricds community which resolves conflicts with predefined
> rules on master master replication
> Best REgards
>
>
> akshay chandratre <akshaychandratre44@gmail.com>, 6 Nis 2026 Pzt, 09:25
> tarihinde şunu yazdı:
>
>> Hi Everyone,
>>
>> The client required the multimaster replication on the production
>> environment. I want help regarding the following things:
>> 1. How to setup multi-master replication on postgresql ?
>> 2. How to handle the conflicts regarding the writes on both masters
>> servers ?
>> 3. Is it reliable for production ? Any other suggestions or options for
>> multimaster ?
>>
>> Postgresql V18
>> Os: centOS
>>
>> Thanks in advance...
>>
>
>
> --
>
> *Muhammet KURTOĞLU*
>
> T: +90(312) 220 12 20 <%2B90%28374%29%20262%2098%2000>
>
> F: +90(312) 286 00 10 <%2B90%28374%29%20262%2090%2091>
>
> muhammet.kurtoglu@bisoft.com.tr <caner.olkan@bisoft.com.tr>
>
>
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How to setup Multi-master replication on postgresql 18
2026-04-06 06:25 How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-06 07:09 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-06 11:44 ` Re: How to setup Multi-master replication on postgresql 18 Mahendra Singh <msmahendrasingh18@gmail.com>
@ 2026-04-07 07:09 ` akshay chandratre <akshaychandratre44@gmail.com>
2026-04-07 07:17 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
0 siblings, 1 reply; 9+ messages in thread
From: akshay chandratre @ 2026-04-07 07:09 UTC (permalink / raw)
To: Mahendra Singh <msmahendrasingh18@gmail.com>; +Cc: Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi Muhammet,
Thanks for suggesting symetricds community.
Will check that out. But my organization wants something open-source. And
on core postgresql.
On Mon, Apr 6, 2026 at 5:13 PM Mahendra Singh <msmahendrasingh18@gmail.com>
wrote:
> Dear Akshay,
>
> The answer is *EDB Postgres Distributed.*
>
> On Mon, Apr 6, 2026 at 11:09 AM Muhammet Kurtoğlu <
> muhammet.kurtoglu@bisoft.com.tr> wrote:
>
>> Hi,
>> You can use symetricds community which resolves conflicts with
>> predefined rules on master master replication
>> Best REgards
>>
>>
>> akshay chandratre <akshaychandratre44@gmail.com>, 6 Nis 2026 Pzt, 09:25
>> tarihinde şunu yazdı:
>>
>>> Hi Everyone,
>>>
>>> The client required the multimaster replication on the production
>>> environment. I want help regarding the following things:
>>> 1. How to setup multi-master replication on postgresql ?
>>> 2. How to handle the conflicts regarding the writes on both masters
>>> servers ?
>>> 3. Is it reliable for production ? Any other suggestions or options for
>>> multimaster ?
>>>
>>> Postgresql V18
>>> Os: centOS
>>>
>>> Thanks in advance...
>>>
>>
>>
>> --
>>
>> *Muhammet KURTOĞLU*
>>
>> T: +90(312) 220 12 20 <%2B90%28374%29%20262%2098%2000>
>>
>> F: +90(312) 286 00 10 <%2B90%28374%29%20262%2090%2091>
>>
>> muhammet.kurtoglu@bisoft.com.tr <caner.olkan@bisoft.com.tr>
>>
>>
>>
>>
>>
>>
>>
>>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How to setup Multi-master replication on postgresql 18
2026-04-06 06:25 How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-06 07:09 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-06 11:44 ` Re: How to setup Multi-master replication on postgresql 18 Mahendra Singh <msmahendrasingh18@gmail.com>
2026-04-07 07:09 ` Re: How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
@ 2026-04-07 07:17 ` Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-07 08:16 ` Re: How to setup Multi-master replication on postgresql 18 Rajni Baliyan <saan654@gmail.com>
0 siblings, 1 reply; 9+ messages in thread
From: Muhammet Kurtoğlu @ 2026-04-07 07:17 UTC (permalink / raw)
To: akshay chandratre <akshaychandratre44@gmail.com>; +Cc: Mahendra Singh <msmahendrasingh18@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
You can use pg_logical extension then
*Muhammet KURTOĞLU*
T: +90(312) 220 12 20 <%2B90%28374%29%20262%2098%2000>
F: +90(312) 286 00 10 <%2B90%28374%29%20262%2090%2091>
muhammet.kurtoglu@bisoft.com.tr <caner.olkan@bisoft.com.tr>
7 Nis 2026 Sal, saat 10:09 tarihinde akshay chandratre <
akshaychandratre44@gmail.com> şunu yazdı:
> Hi Muhammet,
>
> Thanks for suggesting symetricds community.
>
> Will check that out. But my organization wants something open-source. And
> on core postgresql.
>
> On Mon, Apr 6, 2026 at 5:13 PM Mahendra Singh <msmahendrasingh18@gmail.com>
> wrote:
>
>> Dear Akshay,
>>
>> The answer is *EDB Postgres Distributed.*
>>
>> On Mon, Apr 6, 2026 at 11:09 AM Muhammet Kurtoğlu <
>> muhammet.kurtoglu@bisoft.com.tr> wrote:
>>
>>> Hi,
>>> You can use symetricds community which resolves conflicts with
>>> predefined rules on master master replication
>>> Best REgards
>>>
>>>
>>> akshay chandratre <akshaychandratre44@gmail.com>, 6 Nis 2026 Pzt, 09:25
>>> tarihinde şunu yazdı:
>>>
>>>> Hi Everyone,
>>>>
>>>> The client required the multimaster replication on the production
>>>> environment. I want help regarding the following things:
>>>> 1. How to setup multi-master replication on postgresql ?
>>>> 2. How to handle the conflicts regarding the writes on both masters
>>>> servers ?
>>>> 3. Is it reliable for production ? Any other suggestions or options for
>>>> multimaster ?
>>>>
>>>> Postgresql V18
>>>> Os: centOS
>>>>
>>>> Thanks in advance...
>>>>
>>>
>>>
>>> --
>>>
>>> *Muhammet KURTOĞLU*
>>>
>>> T: +90(312) 220 12 20 <%2B90%28374%29%20262%2098%2000>
>>>
>>> F: +90(312) 286 00 10 <%2B90%28374%29%20262%2090%2091>
>>>
>>> muhammet.kurtoglu@bisoft.com.tr <caner.olkan@bisoft.com.tr>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How to setup Multi-master replication on postgresql 18
2026-04-06 06:25 How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-06 07:09 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-06 11:44 ` Re: How to setup Multi-master replication on postgresql 18 Mahendra Singh <msmahendrasingh18@gmail.com>
2026-04-07 07:09 ` Re: How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-07 07:17 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
@ 2026-04-07 08:16 ` Rajni Baliyan <saan654@gmail.com>
2026-04-07 12:45 ` Re: How to setup Multi-master replication on postgresql 18 Laurenz Albe <laurenz.albe@cybertec.at>
2026-04-07 16:51 ` RE: How to setup Multi-master replication on postgresql 18 Jorge Batista <Jorge.Batista@premier-research.com>
0 siblings, 2 replies; 9+ messages in thread
From: Rajni Baliyan @ 2026-04-07 08:16 UTC (permalink / raw)
To: Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>; +Cc: akshay chandratre <akshaychandratre44@gmail.com>; Mahendra Singh <msmahendrasingh18@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi Muhammet,
You can achieve at certain level multi master replication using postgres
native logical replication. Latest version 18 has good conflict resolution
as well.
https://www.postgresql.org/docs/current/logical-replication.html
On Tue, 7 Apr 2026, 5:17 pm Muhammet Kurtoğlu, <
muhammet.kurtoglu@bisoft.com.tr> wrote:
> You can use pg_logical extension then
>
> *Muhammet KURTOĞLU*
>
> T: +90(312) 220 12 20 <%2B90%28374%29%20262%2098%2000>
>
> F: +90(312) 286 00 10 <%2B90%28374%29%20262%2090%2091>
>
> muhammet.kurtoglu@bisoft.com.tr <caner.olkan@bisoft.com.tr>
>
>
>
>
>
>
>
>
>
> 7 Nis 2026 Sal, saat 10:09 tarihinde akshay chandratre <
> akshaychandratre44@gmail.com> şunu yazdı:
>
>> Hi Muhammet,
>>
>> Thanks for suggesting symetricds community.
>>
>> Will check that out. But my organization wants something open-source. And
>> on core postgresql.
>>
>> On Mon, Apr 6, 2026 at 5:13 PM Mahendra Singh <
>> msmahendrasingh18@gmail.com> wrote:
>>
>>> Dear Akshay,
>>>
>>> The answer is *EDB Postgres Distributed.*
>>>
>>> On Mon, Apr 6, 2026 at 11:09 AM Muhammet Kurtoğlu <
>>> muhammet.kurtoglu@bisoft.com.tr> wrote:
>>>
>>>> Hi,
>>>> You can use symetricds community which resolves conflicts with
>>>> predefined rules on master master replication
>>>> Best REgards
>>>>
>>>>
>>>> akshay chandratre <akshaychandratre44@gmail.com>, 6 Nis 2026 Pzt,
>>>> 09:25 tarihinde şunu yazdı:
>>>>
>>>>> Hi Everyone,
>>>>>
>>>>> The client required the multimaster replication on the production
>>>>> environment. I want help regarding the following things:
>>>>> 1. How to setup multi-master replication on postgresql ?
>>>>> 2. How to handle the conflicts regarding the writes on both masters
>>>>> servers ?
>>>>> 3. Is it reliable for production ? Any other suggestions or options
>>>>> for multimaster ?
>>>>>
>>>>> Postgresql V18
>>>>> Os: centOS
>>>>>
>>>>> Thanks in advance...
>>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> *Muhammet KURTOĞLU*
>>>>
>>>> T: +90(312) 220 12 20 <%2B90%28374%29%20262%2098%2000>
>>>>
>>>> F: +90(312) 286 00 10 <%2B90%28374%29%20262%2090%2091>
>>>>
>>>> muhammet.kurtoglu@bisoft.com.tr <caner.olkan@bisoft.com.tr>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How to setup Multi-master replication on postgresql 18
2026-04-06 06:25 How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-06 07:09 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-06 11:44 ` Re: How to setup Multi-master replication on postgresql 18 Mahendra Singh <msmahendrasingh18@gmail.com>
2026-04-07 07:09 ` Re: How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-07 07:17 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-07 08:16 ` Re: How to setup Multi-master replication on postgresql 18 Rajni Baliyan <saan654@gmail.com>
@ 2026-04-07 12:45 ` Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 9+ messages in thread
From: Laurenz Albe @ 2026-04-07 12:45 UTC (permalink / raw)
To: Rajni Baliyan <saan654@gmail.com>; Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>; +Cc: akshay chandratre <akshaychandratre44@gmail.com>; Mahendra Singh <msmahendrasingh18@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
On Tue, 2026-04-07 at 18:16 +1000, Rajni Baliyan wrote:
> You can achieve at certain level multi master replication using postgres
> native logical replication. Latest version 18 has good conflict resolution as well.
> https://www.postgresql.org/docs/current/logical-replication.html
What? There is no conflict resolution.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: How to setup Multi-master replication on postgresql 18
2026-04-06 06:25 How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-06 07:09 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-06 11:44 ` Re: How to setup Multi-master replication on postgresql 18 Mahendra Singh <msmahendrasingh18@gmail.com>
2026-04-07 07:09 ` Re: How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-07 07:17 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-07 08:16 ` Re: How to setup Multi-master replication on postgresql 18 Rajni Baliyan <saan654@gmail.com>
@ 2026-04-07 16:51 ` Jorge Batista <Jorge.Batista@premier-research.com>
2026-04-08 04:34 ` Re: How to setup Multi-master replication on postgresql 18 Eduar Flow <eduarshorybalbuena77@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: Jorge Batista @ 2026-04-07 16:51 UTC (permalink / raw)
To: Rajni Baliyan <saan654@gmail.com>; Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>; +Cc: akshay chandratre <akshaychandratre44@gmail.com>; Mahendra Singh <msmahendrasingh18@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
PostgreSQL logical replication supports bidirectional setups, but conflict handling is not automated. The documentation itself highlights that conflicts can arise when multiple nodes accept writes and resolving them is left to the application or design strategy.
If the requirement is strictly open-source and limited to core PostgreSQL, the most direct option would be bi-directional logical replication (native or pglogical).
That said, PostgreSQL does not provide a fully managed multi-master solution. In practice, this means:
* No built-in conflict resolution (conflicts can stop replication)
* Risk of duplicate keys / concurrent update issues
* Sequences need coordination (or UUIDs)
* DDL is not automatically replicated
* Operational complexity increases significantly
Because of this, the safest approach is usually to define data ownership per node (e.g., by tenant or region) to avoid conflicts rather than trying to resolve them after the fact.
Otherwise, pure core PostgreSQL multi-master setups can be difficult to operate reliably in production.
Regards
From: Rajni Baliyan <saan654@gmail.com>
Sent: Tuesday, April 7, 2026 4:16 AM
To: Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
Cc: akshay chandratre <akshaychandratre44@gmail.com>; Mahendra Singh <msmahendrasingh18@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: How to setup Multi-master replication on postgresql 18
EXTERNAL: This email originated from outside of our organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
Hi Muhammet,
You can achieve at certain level multi master replication using postgres native logical replication. Latest version 18 has good conflict resolution as well.
https://www.postgresql.org/docs/current/logical-replication.html<https://protect.checkpoint.com/v...;
On Tue, 7 Apr 2026, 5:17 pm Muhammet Kurtoğlu, <muhammet.kurtoglu@bisoft.com.tr<mailto:muhammet.kurtoglu@bisoft.com.tr>> wrote:
You can use pg_logical extension then
Muhammet KURTOĞLU
T: +90(312) 220 12 20<tel:%2B90%28374%29%20262%2098%2000>
F: +90(312) 286 00 10<tel:%2B90%28374%29%20262%2090%2091>
muhammet.kurtoglu@bisoft.com.tr<mailto:caner.olkan@bisoft.com.tr>
[http://AttachmentsEmptyImage]
7 Nis 2026 Sal, saat 10:09 tarihinde akshay chandratre <akshaychandratre44@gmail.com<mailto:akshaychandratre44@gmail.com>> şunu yazdı:
Hi Muhammet,
Thanks for suggesting symetricds community.
Will check that out. But my organization wants something open-source. And on core postgresql.
On Mon, Apr 6, 2026 at 5:13 PM Mahendra Singh <msmahendrasingh18@gmail.com<mailto:msmahendrasingh18@gmail.com>> wrote:
Dear Akshay,
The answer is EDB Postgres Distributed.
On Mon, Apr 6, 2026 at 11:09 AM Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr<mailto:muhammet.kurtoglu@bisoft.com.tr>> wrote:
Hi,
You can use symetricds community which resolves conflicts with predefined rules on master master replication
Best REgards
akshay chandratre <akshaychandratre44@gmail.com<mailto:akshaychandratre44@gmail.com>>, 6 Nis 2026 Pzt, 09:25 tarihinde şunu yazdı:
Hi Everyone,
The client required the multimaster replication on the production environment. I want help regarding the following things:
1. How to setup multi-master replication on postgresql ?
2. How to handle the conflicts regarding the writes on both masters servers ?
3. Is it reliable for production ? Any other suggestions or options for multimaster ?
Postgresql V18
Os: centOS
Thanks in advance...
--
Muhammet KURTOĞLU
T: +90(312) 220 12 20<tel:%2B90%28374%29%20262%2098%2000>
F: +90(312) 286 00 10<tel:%2B90%28374%29%20262%2090%2091>
muhammet.kurtoglu@bisoft.com.tr<mailto:caner.olkan@bisoft.com.tr>
[https://mail.google.com/mail/u/0/?ui=2&ik=a8f4776c24&view=fimg&th=15f01658aaf7788e&a...]
________________________________
Notice: This e-mail is intended only for the named person or entity to which it is addressed and contains valuable business information that is privileged, confidential and/or otherwise protected from disclosure. Dissemination, distribution or copying of this e-mail or the information herein by anyone other than the intended recipient, or an employee, or agent responsible for delivering the message to the intended recipient, is strictly prohibited. All contents are the copyright property of the sender. If you are not the intended recipient, you are nevertheless bound to respect the sender's worldwide legal rights. We require that unintended recipients delete the e-mail and destroy all electronic copies in their system, retaining no copies in any media. If you have received this e-mail in error, please immediately notify us by returning the e-mail to the sender. We appreciate your cooperation.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: How to setup Multi-master replication on postgresql 18
2026-04-06 06:25 How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-06 07:09 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-06 11:44 ` Re: How to setup Multi-master replication on postgresql 18 Mahendra Singh <msmahendrasingh18@gmail.com>
2026-04-07 07:09 ` Re: How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-07 07:17 ` Re: How to setup Multi-master replication on postgresql 18 Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-07 08:16 ` Re: How to setup Multi-master replication on postgresql 18 Rajni Baliyan <saan654@gmail.com>
2026-04-07 16:51 ` RE: How to setup Multi-master replication on postgresql 18 Jorge Batista <Jorge.Batista@premier-research.com>
@ 2026-04-08 04:34 ` Eduar Flow <eduarshorybalbuena77@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: Eduar Flow @ 2026-04-08 04:34 UTC (permalink / raw)
To: Jorge Batista <Jorge.Batista@premier-research.com>; +Cc: Rajni Baliyan <saan654@gmail.com>; Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>; akshay chandratre <akshaychandratre44@gmail.com>; Mahendra Singh <msmahendrasingh18@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
1. Instalar PostgreSQL + BDR
BDR no viene incluido en PostgreSQL estándar.
Necesitas EDB Postgres Distributed (antes BDR)
Sitio: EnterpriseDB
2. Configurar parámetros (postgresql.conf)
Conf
wal_level = logical
max_replication_slots = 10
max_wal_senders = 10
max_worker_processes = 20
shared_preload_libraries = 'bdr'
3. Crear base de datos y habilitar BDR
SQL
CREATE DATABASE mydb;
\c mydb
CREATE EXTENSION bdr;
4. Crear nodo
SQL
SELECT bdr.create_node(
node_name := 'node1',
dsn := 'host=IP_NODE1 dbname=mydb user=postgres password=xxx'
);
5. Unir segundo nodo
En el segundo servidor:
SQL
SELECT bdr.join_node(
node_name := 'node2',
dsn := 'host=IP_NODE2 dbname=mydb user=postgres password=xxx',
join_using_dsn := 'host=IP_NODE1 dbname=mydb user=postgres password=xxx'
);
✔️ Ahora ambos pueden escribir (multi-master)
Yekma666
El mar, 7 de abr de 2026, 10:52, Jorge Batista <
Jorge.Batista@premier-research.com> escribió:
> PostgreSQL logical replication supports bidirectional setups, but conflict
> handling is not automated. The documentation itself highlights that
> conflicts can arise when multiple nodes accept writes and resolving them is
> left to the application or design strategy.
>
>
>
> If the requirement is strictly open-source and limited to core PostgreSQL,
> the most direct option would be bi-directional logical replication (native
> or pglogical).
>
>
>
> That said, PostgreSQL does not provide a fully managed multi-master
> solution. In practice, this means:
>
> - No built-in conflict resolution (conflicts can stop replication)
> - Risk of duplicate keys / concurrent update issues
> - Sequences need coordination (or UUIDs)
> - DDL is not automatically replicated
> - Operational complexity increases significantly
>
>
>
> Because of this, the safest approach is usually to define data ownership
> per node (e.g., by tenant or region) to avoid conflicts rather than trying
> to resolve them after the fact.
>
>
>
> Otherwise, pure core PostgreSQL multi-master setups can be difficult to
> operate reliably in production.
>
>
>
> Regards
>
>
>
> *From:* Rajni Baliyan <saan654@gmail.com>
> *Sent:* Tuesday, April 7, 2026 4:16 AM
> *To:* Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
> *Cc:* akshay chandratre <akshaychandratre44@gmail.com>; Mahendra Singh <
> msmahendrasingh18@gmail.com>; Pgsql-admin <
> pgsql-admin@lists.postgresql.org>
> *Subject:* Re: How to setup Multi-master replication on postgresql 18
>
>
>
> EXTERNAL: This email originated from outside of our organization. Do not
> click links or open attachments unless you recognize the sender and know
> the content is safe.
>
>
>
> Hi Muhammet,
>
> You can achieve at certain level multi master replication using postgres
> native logical replication. Latest version 18 has good conflict resolution
> as well.
>
> https://www.postgresql.org/docs/current/logical-replication.html
> <https://protect.checkpoint.com/v2/r01/___https:/www.postgresql.org/docs/current/logical-replication....;
>
>
>
>
> On Tue, 7 Apr 2026, 5:17 pm Muhammet Kurtoğlu, <
> muhammet.kurtoglu@bisoft.com.tr> wrote:
>
> You can use pg_logical extension then
>
> *Muhammet KURTOĞLU*
>
> T: +90(312) 220 12 20 <%2B90%28374%29%20262%2098%2000>
>
> F: +90(312) 286 00 10 <%2B90%28374%29%20262%2090%2091>
>
> muhammet.kurtoglu@bisoft.com.tr <caner.olkan@bisoft.com.tr>
>
>
>
>
>
>
>
>
>
>
> 7 Nis 2026 Sal, saat 10:09 tarihinde akshay chandratre <
> akshaychandratre44@gmail.com> şunu yazdı:
>
> Hi Muhammet,
>
> Thanks for suggesting symetricds community.
>
> Will check that out. But my organization wants something open-source. And
> on core postgresql.
>
>
>
> On Mon, Apr 6, 2026 at 5:13 PM Mahendra Singh <msmahendrasingh18@gmail.com>
> wrote:
>
> Dear Akshay,
>
>
>
> The answer is *EDB Postgres Distributed.*
>
>
>
> On Mon, Apr 6, 2026 at 11:09 AM Muhammet Kurtoğlu <
> muhammet.kurtoglu@bisoft.com.tr> wrote:
>
> Hi,
>
> You can use symetricds community which resolves conflicts with predefined
> rules on master master replication
>
> Best REgards
>
>
>
>
>
> akshay chandratre <akshaychandratre44@gmail.com>, 6 Nis 2026 Pzt, 09:25
> tarihinde şunu yazdı:
>
> Hi Everyone,
>
> The client required the multimaster replication on the production
> environment. I want help regarding the following things:
> 1. How to setup multi-master replication on postgresql ?
> 2. How to handle the conflicts regarding the writes on both masters
> servers ?
> 3. Is it reliable for production ? Any other suggestions or options for
> multimaster ?
>
> Postgresql V18
> Os: centOS
>
>
>
> Thanks in advance...
>
>
>
>
> --
>
> *Muhammet KURTOĞLU*
>
> T: +90(312) 220 12 20 <%2B90%28374%29%20262%2098%2000>
>
> F: +90(312) 286 00 10 <%2B90%28374%29%20262%2090%2091>
>
> muhammet.kurtoglu@bisoft.com.tr <caner.olkan@bisoft.com.tr>
>
>
>
>
>
>
>
> ------------------------------
>
> Notice: This e-mail is intended only for the named person or entity to
> which it is addressed and contains valuable business information that is
> privileged, confidential and/or otherwise protected from disclosure.
> Dissemination, distribution or copying of this e-mail or the information
> herein by anyone other than the intended recipient, or an employee, or
> agent responsible for delivering the message to the intended recipient, is
> strictly prohibited. All contents are the copyright property of the sender.
> If you are not the intended recipient, you are nevertheless bound to
> respect the sender's worldwide legal rights. We require that unintended
> recipients delete the e-mail and destroy all electronic copies in their
> system, retaining no copies in any media. If you have received this e-mail
> in error, please immediately notify us by returning the e-mail to the
> sender. We appreciate your cooperation.
>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2026-04-08 04:34 UTC | newest]
Thread overview: 9+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-04-06 06:25 How to setup Multi-master replication on postgresql 18 akshay chandratre <akshaychandratre44@gmail.com>
2026-04-06 07:09 ` Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-06 11:44 ` Mahendra Singh <msmahendrasingh18@gmail.com>
2026-04-07 07:09 ` akshay chandratre <akshaychandratre44@gmail.com>
2026-04-07 07:17 ` Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
2026-04-07 08:16 ` Rajni Baliyan <saan654@gmail.com>
2026-04-07 12:45 ` Laurenz Albe <laurenz.albe@cybertec.at>
2026-04-07 16:51 ` Jorge Batista <Jorge.Batista@premier-research.com>
2026-04-08 04:34 ` Eduar Flow <eduarshorybalbuena77@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox