public inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Rajni Baliyan <saan654@gmail.com>
To: Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr>
Cc: akshay chandratre <akshaychandratre44@gmail.com>
Cc: Mahendra Singh <msmahendrasingh18@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: How to setup Multi-master replication on postgresql 18
Date: Tue, 7 Apr 2026 18:16:11 +1000
Message-ID: <CAG5ROROEOVF0RLWnUemaa6tnU92Ys3oxTyMHRRynv2znKoTvDg@mail.gmail.com> (raw)
In-Reply-To: <CANM7_8W8VrSpzHOtr7cz_MSkZmU--oBhqD2atUnjLrG-doGs0w@mail.gmail.com>
References: <CAM4Za0x46sgmAqaKxfm6=gRET782hZ8sMA-DgzX3eDLnAtDEkg@mail.gmail.com>
<CANM7_8Uq9QKAX_SAcNcYz6AjZ32sYgiB5iMV45BcuHaAdDOV3A@mail.gmail.com>
<CA+Thq8HDSvSvUNrbsad+kC+yOuOd1yQzw-k=Q2r1y77hnNnSXA@mail.gmail.com>
<CAM4Za0yTj9yjksEZ3kAW296p04egz5qPiaVe7mLNgyL9qNCmKw@mail.gmail.com>
<CANM7_8W8VrSpzHOtr7cz_MSkZmU--oBhqD2atUnjLrG-doGs0w@mail.gmail.com>
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>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: saan654@gmail.com, muhammet.kurtoglu@bisoft.com.tr, akshaychandratre44@gmail.com, msmahendrasingh18@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: How to setup Multi-master replication on postgresql 18
In-Reply-To: <CAG5ROROEOVF0RLWnUemaa6tnU92Ys3oxTyMHRRynv2znKoTvDg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox