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 1wA0ge-001ynU-1q for pgsql-admin@arkaria.postgresql.org; Tue, 07 Apr 2026 07:17:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wA0gc-00FEWM-2f for pgsql-admin@arkaria.postgresql.org; Tue, 07 Apr 2026 07:17:23 +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 1wA0gc-00FEWE-0g for pgsql-admin@lists.postgresql.org; Tue, 07 Apr 2026 07:17:22 +0000 Received: from mail-ed1-x529.google.com ([2a00:1450:4864:20::529]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wA0ga-00000000zSC-0sMv for pgsql-admin@lists.postgresql.org; Tue, 07 Apr 2026 07:17:21 +0000 Received: by mail-ed1-x529.google.com with SMTP id 4fb4d7f45d1cf-66bb3766125so399390a12.2 for ; Tue, 07 Apr 2026 00:17:19 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775546238; cv=none; d=google.com; s=arc-20240605; b=KEF/UWmtvb2V2gIuea699/qO2kT0v/3pQN+b07Ce21AItttvwQaoeUwqr9qb8KDBHL oh1SfwhLz9WzSrjF3fFEGx0Wd2EW8t+9z66tNsGd+iAUFEcea1A3b5kwmH09BHJbJaIH 7xRSL/eBbQVSYqFGTd9M7eQMO2RrLnlTZoBCLWfyxjPPqAspWO3tb9cOw9+MjN1uYKi3 fBcVVEJYuA2lvZ5dxNpjhs/rVcqCO4lJ96pwO41d0sRp25EzvZ3c1NCT3P+rMyp7ihVt Q1ri0l/i7n8OqUtZHFiJfv0DZEMjjaXx82NT5i6p3WwgxPm/iYYQYW/dlWJzNei4Y9SY Dj2Q== 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=eKHmNL9726oll4If6yom5JG3quEraxCDrcXWiTLowV4=; fh=4oSY5Mz6F/hp02lSAwIO8RCAxxKfUxwLdJBkkJf6VkI=; b=YA6n1mIS169WlhHpYilpKyvzlSD5u7BRKECSfUoW70YRLD9kgwvjusPww6+Z4u8j43 C3qtpXWj50fknKlkVf9DVVYx48QxO/8+CuAHXQuOHeoiXg/r+mmGpGfHj+ARuF/78Yki V9X6Ovc/+/ISy1zvuo+ZvzH9p2azx5yJbi7BUAbHvsfNaaAUiNCOxEB6tEe0NcBTrFrn EGfyJqNYNNhnoy+VUMqontlL883jWtxBEef9P/amcvruM0aMMalECwBtQJkVirbXvYDg qp+t0cIQA8TJ8BiiC0Rw7RPEQP4GClQbehjVOyprIwdmxIdKuua4vDRzcdEl9puyCvAi fuZw==; 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=bisoft-com-tr.20251104.gappssmtp.com; s=20251104; t=1775546238; x=1776151038; 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=eKHmNL9726oll4If6yom5JG3quEraxCDrcXWiTLowV4=; b=CpWMVeDkF+ovzfv/iXeKt2yjxRW9ZD4vYQQmzHxfM29rplLeZtRHxuoTTCEUwMAujy fRzxtM22ibw3Grj3kJRky7bPmyaPrSuuITj5gml6zMiWJv8mYPaQj6VJHDGnqY98AaMo 1DM/aY8PHnIIltyCfYwYyMwBqLYKgLAWAXVWMjs3pa/mgRySyMRFo7U9gP0dWWdv3RwF 5cwY8EPHkHGCG4Wud1gITreqH9XKO+5o0MNjpesCS342dULa9b5Lj8OQTbXHgHqNIOC2 3NpmCK8iOZhhoW6GsdHR4fBTgsKeWJAWo5P+NZL1eo8e7B8CpHLyrUUy43kof3slpJjp 0WsA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775546238; x=1776151038; 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=eKHmNL9726oll4If6yom5JG3quEraxCDrcXWiTLowV4=; b=Efr/+T21ApOovEA9JiVtsS6ZiYZnrpE9SOSX10CAHjHa49Kjv8jibkqRKL2f2kaEtr v3ttPgWM+3sa/ED/iRnM6z3J9rCxpy+Z5PAdrpccpCxBvmyexDN0KLcVBKu5GcME/Dwl dDTPR0YXzkokEusw3BnRoQfwbcAnEj49sLDTGbVR5UKNcScApRszUCmj8Alymz+vlSWc NRlQ09UtBoaC6atrv1h/RHipVL3Pj98Pm1fQU2P0O6C5wUR4RQP2faoGG6kPKJq0bvFd 43/xcA2K8YfkeM87SpAhqgBuoizAohX3WppfqXEovnbdYYGoRnlm4mqVsVl/97LLbTlt HF8A== X-Forwarded-Encrypted: i=1; AJvYcCXXRh7dQw65YninNDBzp54IUBWZy06Q/vB8vq2BD2VxvzvQrIKYuFp3nsofwAdSdkK9vqJ1KkGZWYEryQ==@lists.postgresql.org X-Gm-Message-State: AOJu0YxdWH8MZKYWUu43np472/PNPdrmeAuHx6AKFTccVSID+3uKCFuj DU9sA8yj9ypWF/V7cV7ReUvilSIEbe40l/Ofb5mLq7Zb253Z6bSzf2m5iu02wumCz3keElwfUX9 AL8O56vlijkld7MeHrzjS3mEkxm7b4aDx3hglOI7RyQ== X-Gm-Gg: AeBDievWSHzIQfJitK0yYMP4WOoD0BrbQV9VLD5XY2PhXFA2Ldwz3/ECO7/eY8hQcYQ /PSLPRiBxD2Sx+z8MoLOIgK5CeoHn4vSe78txSePtyMtyLQ6gzDjhYiqbfPBrXO0VoP8I43O5sH krTGnKT76XOcSnnzy1+mGR4PqH+L/7wQyJrgxrsvburFy6+KmIZuXuhydX0Ym7flERjXwwlyp/j bZ4Mi2TlwuoRPejlmUnnSpf0UMxez6JvmoN6hTCM2DUOP1D+8IsJfNCWwCoE/Fn4UGHBJXGc5EQ ppdG2tqTlCjm1w== X-Received: by 2002:a05:6402:1475:b0:66e:aae1:13f7 with SMTP id 4fb4d7f45d1cf-66eaae11559mr2003189a12.7.1775546238232; Tue, 07 Apr 2026 00:17:18 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: =?UTF-8?Q?Muhammet_Kurto=C4=9Flu?= Date: Tue, 7 Apr 2026 10:17:07 +0300 X-Gm-Features: AQROBzDJ-5EfTAKWPb630zB2qxTA3_ArGPRgX2sbsVqp36Ik6sAoJBsYyJO1XLA Message-ID: Subject: Re: How to setup Multi-master replication on postgresql 18 To: akshay chandratre Cc: Mahendra Singh , Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000cff9e3064ed992cd" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cff9e3064ed992cd Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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. And > on core postgresql. > > On Mon, Apr 6, 2026 at 5:13=E2=80=AFPM Mahendra Singh > 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 fo= r >>>> 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 >>> >>> >>> >>> >>> >>> >>> >>> --000000000000cff9e3064ed992cd Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
You can use pg_logical extension then

Muhammet KU= RTO=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







7 Nis 2026 Sal, saat 10:09 tarihind= e akshay chandratre <aks= haychandratre44@gmail.com> =C5=9Funu yazd=C4=B1:
Hi Muhammet,

Thanks for sugges= ting 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 <msmahendrasingh18@gmail.com> wrote:
Dear A= kshay,

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

On Mon, Apr 6, 2026 at 11:09=E2=80=AFAM Muhammet Kurto=C4=9Flu <= ;muham= met.kurtoglu@bisoft.com.tr> wrote:
Hi,
=C2=A0You can use symetr= icds=C2=A0community which resolves conflicts with predefined rules on maste= r master replication
Best REgards


<= div class=3D"gmail_quote">
akshay chan= dratre <akshaychandratre44@gmail.com>, 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 follo= wing things:
1. How to setup=C2=A0multi-master replication on postgresql= ?
2. How to handle the conflicts regarding the writes on both masters s= ervers=C2=A0?
3. Is it reliable for production ? Any other suggestions o= r options for multimaster ?

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(31= 2) 286 00 10=

muhammet.kurtoglu@bisoft.com.tr=C2=A0<= /span>

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

=


=


--000000000000cff9e3064ed992cd--