| From: | Rajni Baliyan <saan654(at)gmail(dot)com> |
|---|---|
| To: | Muhammet Kurtoğlu <muhammet(dot)kurtoglu(at)bisoft(dot)com(dot)tr> |
| Cc: | akshay chandratre <akshaychandratre44(at)gmail(dot)com>, Mahendra Singh <msmahendrasingh18(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How to setup Multi-master replication on postgresql 18 |
| Date: | 2026-04-07 08:16:11 |
| Message-ID: | CAG5ROROEOVF0RLWnUemaa6tnU92Ys3oxTyMHRRynv2znKoTvDg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(dot)kurtoglu(at)bisoft(dot)com(dot)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(dot)kurtoglu(at)bisoft(dot)com(dot)tr <caner(dot)olkan(at)bisoft(dot)com(dot)tr>
>
>
>
>
>
>
>
>
>
> 7 Nis 2026 Sal, saat 10:09 tarihinde akshay chandratre <
> akshaychandratre44(at)gmail(dot)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(at)gmail(dot)com> wrote:
>>
>>> Dear Akshay,
>>>
>>> The answer is *EDB Postgres Distributed.*
>>>
>>> On Mon, Apr 6, 2026 at 11:09 AM Muhammet Kurtoğlu <
>>> muhammet(dot)kurtoglu(at)bisoft(dot)com(dot)tr> wrote:
>>>
>>>> Hi,
>>>> You can use symetricds community which resolves conflicts with
>>>> predefined rules on master master replication
>>>> Best REgards
>>>>
>>>>
>>>> akshay chandratre <akshaychandratre44(at)gmail(dot)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(dot)kurtoglu(at)bisoft(dot)com(dot)tr <caner(dot)olkan(at)bisoft(dot)com(dot)tr>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2026-04-07 12:45:06 | Re: How to setup Multi-master replication on postgresql 18 |
| Previous Message | Muhammet Kurtoğlu | 2026-04-07 07:17:07 | Re: How to setup Multi-master replication on postgresql 18 |