Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wA1br-001zcw-1C for pgsql-admin@arkaria.postgresql.org; Tue, 07 Apr 2026 08:16:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wA1bp-00Ff7E-2W for pgsql-admin@arkaria.postgresql.org; Tue, 07 Apr 2026 08:16:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wA1bp-00Ff76-0i for pgsql-admin@lists.postgresql.org; Tue, 07 Apr 2026 08:16:29 +0000 Received: from mail-lf1-x134.google.com ([2a00:1450:4864:20::134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wA1bn-00000000zuc-1xpY for pgsql-admin@lists.postgresql.org; Tue, 07 Apr 2026 08:16:28 +0000 Received: by mail-lf1-x134.google.com with SMTP id 2adb3069b0e04-5a0faa0d15cso5463536e87.0 for ; Tue, 07 Apr 2026 01:16:27 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775549786; cv=none; d=google.com; s=arc-20240605; b=V9Ah+n6CBHZZsSWLRozJXheI16a3alOwLyzOe/LP358G5tAPI8sZKqvDN6KZakxrKq o2oVqrUvjeJVOvtsNR44b3O8AdgMIE7MFS1a0GBg4kgcnKSNbs4Ue88gnMM0lhqIRXcV V6sjsyN7Ngdq81N2ZJdHUvJ1PPe8W6bFR//0RNuZ4KTOxqY1P3W8PGEg6P1L01uVL/bB XDn+kz4hmY4owp+5vwQx95KtYXvKtDxuisUJ7KK7XrsqvnW27QGluZ9HMVES6MUSWWrf Dw+RwT7ac6Vwh5r1sLD46JqBq4l0kmQy+OZXKm33MQsZUqZrjsapklbIhl3vJZeoHrFm kjJg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=+r3HLEB4KaCPJpXGmXoSXjRl6HW2L9bEnyWXKkpVBbU=; fh=TjKu8i/0mlJqtnrm0n9YboT7zl9F8SUTJLe0YAa4Ofc=; b=KvhPD1lPXMXrLqknaEbaKuy+EcGThqpUtmzlrzVQXCRY04zGOhxN9zU11iyLNz9QFe OuFNg9DX5+L2RM8Rn6DB4wfdZI+KqAxeSRSO1i8PTR2BUf0X71TAL3MgxrHVh1raR6Fo wuRXaJu/DyZZgzJEGO/1MzkkxMOdbGWfoGqi8Wtj5/dvvpBBlge38t92YG8imBfb7D48 lgkbfYx/zgAZuhnqtzI6GYxPk3fAAjRONwOkPq3Oc856+oOqIH7Uc4YXNdZ45PKkvrme LY5fZWk01Yp+w7gm03cs49PPfEruoo2UO9OE7u8YlBOBAi3Ewa3RwGcmwX8WaeYR+bf5 c1hQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775549786; x=1776154586; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=+r3HLEB4KaCPJpXGmXoSXjRl6HW2L9bEnyWXKkpVBbU=; b=bbBKoN2Bc9G6mKGpoAO2DIzwPDWuzmMfp9t0ALuy64RDa800unz7/LNtDtfNwOfkVs X2Orpom7aokg9pXxTFFPPAsszrrlFeRjPcJ4noatO9Pla8FuG0JyOG/5GEci4GL/HsTe QNyB35TWy7LQbOXH9lrH0jssiFFuiu7mfTB9w1GKToVr6ZkB6s/pXgEwaK1XMDYk5VCb jeh1VPu4GhPWAWD1OKAbUavswDoL/GNxFp2nk9sLJZNWAgpkxyhTW3WmSTL1vnXEkeCI tWwcIi09bcdjl+YqHUWxlgAKeC1RbWZab1sEo8FXhwSSzK6vqMTzl/VH+h2wZFMu4zzx Jt8w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775549786; x=1776154586; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=+r3HLEB4KaCPJpXGmXoSXjRl6HW2L9bEnyWXKkpVBbU=; b=rgo/H1ZSvMcXZv4wSPV6wmTdUcZ5FBO0DXxcYBbq/0wNdHchx+wAbHrKtSyyC8ZIJR M2jA6Gt1wpKQwrJahf4eM83N7PIUchQ2LieE/F5gI4tpQckZ8NIgHzgmee83zWSUgxGk f3gJN7xJogEzs9v0ayx6fopJuHwqGUvR00PXLyU1sM3FVQT8EZR8SVnpkauSFCyO2i/1 LK0xEiBh4V9zFNzN5IZOxygsLhz+j2wNojUQGeAu3/z8bzMH53AfbfEHkD/B3sHQiZu/ MoGCsTTVf8EOLFQt4NxermZ/4isCJkqoZUrjUpbSAqfutT08m2+lPlWyI5aBPdN7qIuu cizA== X-Forwarded-Encrypted: i=1; AJvYcCWu2O+jNrGv+xnp1T2oejAbgiehDNvtUBnGXe/qqahERus5PtOT4YPljkae7ki8t8QRe82NQmYXkJCgrw==@lists.postgresql.org X-Gm-Message-State: AOJu0YyzmziQx/jHx5SIFNv+4iJinQlmuXBT1EweCnLbOOfwS++0LQ80 kS8tGeD6UCdxweQQ0TjwkbZQapdtGw9iSORv2S8IPSSaQUCM+9gQMdjcBvLRJLpKdHdjrf6WH/h nfz5YyRLOtfu68PzXAaRrOjKAWQGDrfA= X-Gm-Gg: AeBDieuN0XD951gVkTFNMb8X2E5d/G5Tw8ub/3zisQ1BASDwYIW29j9wmlXI8yP1aU/ SK1qe6W1HepODzHaJ6q78IQ2/jTZrNSu68fEp7kJowXdUYrMRA6eFpGS+Fy9fLA9la38AZRiqEk I/tFQxr+IBXzrEhWV05JOcMl2wqgvvSgueu8ilDvDreBXxFIbfzOCgEzX65pneAbSZbrp52FLXQ J+WEs8ZorzPOjcng6cE+5XWVEGHPSkBidlrLA7SvFK9A7PLtM7xHaSkhk31xwyhzUbf29Z8EfZ7 h5j2WqkWPYdZvD+uHB1W4C5GOvQLBnGXcuzwPBHR X-Received: by 2002:a05:6512:6d3:b0:5a2:b889:3b79 with SMTP id 2adb3069b0e04-5a337552805mr5032508e87.2.1775549785208; Tue, 07 Apr 2026 01:16:25 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Rajni Baliyan Date: Tue, 7 Apr 2026 18:16:11 +1000 X-Gm-Features: AQROBzBEB5DArpC_kw1CTq1ltiBMgp3-xzWoEICt0qFTYj12lKR7QGhmLjKO4WU Message-ID: Subject: Re: How to setup Multi-master replication on postgresql 18 To: =?UTF-8?Q?Muhammet_Kurto=C4=9Flu?= Cc: akshay chandratre , Mahendra Singh , Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000003a7bb3064eda6603" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003a7bb3064eda6603 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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=E2=80=AFpm Muhammet Kurto=C4=9Flu, < muhammet.kurtoglu@bisoft.com.tr> wrote: > You can use pg_logical extension then > > *Muhammet KURTO=C4=9ELU* > > 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 > > > > > > > > > > 7 Nis 2026 Sal, saat 10:09 tarihinde akshay chandratre < > akshaychandratre44@gmail.com> =C5=9Funu yazd=C4=B1: > >> Hi Muhammet, >> >> Thanks for suggesting symetricds community. >> >> Will check that out. But my organization wants something open-source. An= d >> on core postgresql. >> >> On Mon, Apr 6, 2026 at 5:13=E2=80=AFPM Mahendra Singh < >> msmahendrasingh18@gmail.com> wrote: >> >>> Dear Akshay, >>> >>> The answer is *EDB Postgres Distributed.* >>> >>> On Mon, Apr 6, 2026 at 11:09=E2=80=AFAM Muhammet Kurto=C4=9Flu < >>> 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 , 6 Nis 2026 Pzt, >>>> 09:25 tarihinde =C5=9Funu yazd=C4=B1: >>>> >>>>> 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=C4=9ELU* >>>> >>>> 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 >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> --0000000000003a7bb3064eda6603 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Muhammet,
You can achieve at certain = level multi master replication using postgres native logical replication. L= atest version 18 has good conflict resolution as well.

On Tue, 7 Apr 2026, 5:17=E2=80=AFpm Muhammet Kurto=C4=9Flu, <= ;muhammet.kurtoglu@bisoft.com.tr> wrote:
You can use pg_logical extens= ion then

<= div dir=3D"ltr">
<= /tbody>
Muhammet KURTO=C4=9ELU

T:=C2=A0=C2=A0+90(312) 220 12 20

F:=C2=A0=C2=A0+90(312) 286 00 10

muhammet.kurtoglu@bisoft.com.tr=C2=A0

=C2=A0=C2=A0=C2=A0=C2=A0





<= /div>


7 Nis 2026 Sal, saat 10:09 tarihinde aksh= ay chandratre <akshaychandratre44@gmail.com>= =C5=9Funu yazd=C4=B1:
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=E2=80=AFPM Mahendra Singh &l= t;msmahendrasingh18@gmail.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft:1px solid rgb(204,204,204);padding-left:1ex">
Dear Aksh= ay,

The answer is EDB Postgres Distributed.=C2=A0=

On Mon, Apr 6, 2026 at 11:09=E2=80=AFAM Muhammet Kurto=C4=9Flu <muhammet.kurtoglu@bisoft.com.tr> wrote:
Hi,=C2=A0You can use symetricds=C2=A0community which resolves conflicts wit= h predefined rules on master master replication
Best REgards


akshay chandratre <akshaychandratre= 44@gmail.com>, 6 Nis 2026 Pzt, 09:25 tarihinde =C5=9Funu yazd=C4=B1:=
Hi Everyone,

The client required the multimaster replication on th= e production environment. I want help regarding the following things:
1.= How to setup=C2=A0multi-master replication on postgresql ?
2. How to ha= ndle the conflicts regarding the writes on both masters servers=C2=A0?
3= . Is it reliable for production ? Any other suggestions or options for mult= imaster ?

Postgresql V18
Os: centOS

Thanks in = advance...


--

Muhammet KURTO=C4=9ELU=

T:=C2=A0=C2=A0+= 90(312) 220 12 20

F:=C2=A0=C2=A0+90(312) 286 00 10

<= span lang=3D"EN-US" style=3D"font-size:10pt;font-family:Arial,sans-serif"><= a href=3D"mailto:caner.olkan@bisoft.com.tr" style=3D"color:rgb(17,85,204)" = rel=3D"noreferrer noreferrer" target=3D"_blank">muhammet.kurtoglu@bisoft.co= m.tr=C2=A0

=C2=A0=C2=A0= =C2=A0=C2=A0





--0000000000003a7bb3064eda6603--