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 1wA0ZA-001ygn-2p for pgsql-admin@arkaria.postgresql.org; Tue, 07 Apr 2026 07:09:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wA0Z9-00FB6E-0w for pgsql-admin@arkaria.postgresql.org; Tue, 07 Apr 2026 07:09:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wA0Z8-00FB64-2n for pgsql-admin@lists.postgresql.org; Tue, 07 Apr 2026 07:09:39 +0000 Received: from mail-yx1-xb12e.google.com ([2607:f8b0:4864:20::b12e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wA0Z6-000000013Aa-21zW for pgsql-admin@lists.postgresql.org; Tue, 07 Apr 2026 07:09:39 +0000 Received: by mail-yx1-xb12e.google.com with SMTP id 956f58d0204a3-650182d19e0so5280840d50.1 for ; Tue, 07 Apr 2026 00:09:36 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775545775; cv=none; d=google.com; s=arc-20240605; b=AyV+8dLLPs0j0Qf1jufqM3S4oI8qXtuPxbJEsns5X3RI+ws3EUsrcl2tNFUZaMZZ+C cmHqXA+/lv1nBr8o8HLE/yDI8A0m2uJ8Nv6O+vqlkj5nEWmtaP9CJH6kmBwcgWyC3m0v zDRj8S6yJD7csraxeuA+LspXNFyD6zv8FAu/58zLjvxi0SRZudElnol3AwpEnWHXyk8s ise/GCx87RNdrDQyBDdB5zbqDXnoLYjOdryVnBJMRkNDzMlxhP7LlUVeiitPLIXOPEUh W9eypRuHUecE35p38SnxOQ9JxG1YIgPIrOjwmjWaIEk1Xc72O//hVrh8E4uqpEYZ8KsX cRgg== 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=3FxbOqwZYWeLcQS4JVJUMfE+qkn+U/ykq4hPH5TAIDY=; fh=/5PhvjVkmmDX5YI2hy6cjnS6viwh1qB2bgzDoyoxzCQ=; b=a2+3/StmjqanASEjzNKbpsDl80UPPi/kne88bKw+jkNEdWTm4dl8Sl/7sfmd/goYTi Xhur31ztscvyPoLrkgNAi/D/hh3bv3G+rm77nRSdGWjuDoPAlH+I1ViyQx6ACDxYIPu9 xEAt0JsltsFgjMUsDRlYUpRTBI11C6jOfdLB8dtDwrtrKvMOVwNFS3FL+2pqOCki3ZRT aJT3ml7fYqGzZzxctDQ/ywXx95h7nQqTdqnvz3YqFZgL6kGE2ySqQf/x7oMIV73joYy8 /AWZJQd4veOtHPWkU/1JX70/Q5Z9e5vWLJ1Mwt3fq/3DZ7YC/zPIGwHcIlXN8xC13gNL PaIA==; 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=1775545775; x=1776150575; 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=3FxbOqwZYWeLcQS4JVJUMfE+qkn+U/ykq4hPH5TAIDY=; b=B+fne/Ke6HEi/Bngp8R6ovaWSNJQZoHSF5dRp6AUxws/6k7c1rn1dge7yRP7lolr4B 4UpFKRGYbkmJ5fF6TJMOGiYkFSBNrhs4aNwXIQtsqJ00VjetIdFDhk/TJr8tawoakOzi w1peYOQikoLBCFtwhZ+hzszMRO9nvHXNLOCmk1EAvyAe2d6AIEKq6F6B8dbqEI7VWL2Q TYeynxtjGBCsNhgmuvpGNbC1UfUbXVRITAaztOg9cgOQb5eIjT1w4hmqvqGuYDfVlkm6 8bAjydlB6baLZF9ZoIczHiiTDatlRtrOp67A18l0k3qw2s6U6Jmo/fOZatC0A7Uv8pYn bhNA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775545775; x=1776150575; 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=3FxbOqwZYWeLcQS4JVJUMfE+qkn+U/ykq4hPH5TAIDY=; b=W9Enqrqe7ChTbx+CrLB4/9ryRCbUDgZ7481Qay5q8Hug1GpkCMjTPe98IRdXrb+kLT vWLYQa1/QQVbbdCdFOWEZjOvgAORnWydC2cdjN15qeaViZtRfjjeVgX53wgQyssjXQJV 3IraZbdPgaICrs1bpIvckHdrcIfB+nuufdJJz9UPDHe17Yi89ct8iLcWn02UrLVl3mZ0 tITlj/H1Yll9eftr5jEBI8ulnPEEHkfojXkCuW4GVGpe4wi6pS1kFAPfq1QQ129qsvHf vIPo2Iy4VtasCt6xMZFi7hOzF7+1LPszDHPcg0UsDGuZcVoaEUpxJY/AHmYcQQpwGPdO mN3g== X-Forwarded-Encrypted: i=1; AJvYcCVE9e6aX7+0xX515cuX61ne37vrSuLoonlwVKo8zZyAS+sJoctlEOi2JjKlxs/TwIEwu+m6LPJpqQcn/w==@lists.postgresql.org X-Gm-Message-State: AOJu0YyVg4l/XKUv99b8kGCO/0u0jYQzHI0vgRudaES21BTu3NxGPHIA ZlgYTZHL5TjWUh1Iha/oKeFTbx3z6kxxgRvXffpZd0Prr6PJ68qAdGvS+gLMQeWTQgdjwgaom8U MqPNxVAA4e+2lpGtfEDok7veA5HRwZPA= X-Gm-Gg: AeBDieuXAi1Jovebl6vkEoQV7VyMNlTWQuYcf4l6t+i8u2O7HMRMzWW8lVVhjPj92i0 XsoaYacYvcRqW3l371p3O705i7io/sxpyQcRAwP5O3gkwzpMvY+F+yK5fWilBzTbmXXvYoKZgMF DOG5jP3DZ/ypvpVKQROrVFcZH3c53D4LXFUT4FjSJyURbIBAHIHY7jcMg0F0wjFnpgIyVspYLfc NxAps/6pqXjKHTbRpn+wpGd55/NiSfCt1tucimTcs85oVEv0vpRd13BQJLoMh4fCBFSyhNwVXVH RWNfu9t7hQ== X-Received: by 2002:a05:690e:4384:b0:64e:d95a:c89e with SMTP id 956f58d0204a3-65048828596mr10135678d50.41.1775545774348; Tue, 07 Apr 2026 00:09:34 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: akshay chandratre Date: Tue, 7 Apr 2026 12:39:22 +0530 X-Gm-Features: AQROBzCKc1uCBRR1lPBambaXeNBvrnvguv6UBP6uar7eQyresvWOzckaPUqAY4I Message-ID: Subject: Re: How to setup Multi-master replication on postgresql 18 To: Mahendra Singh Cc: =?UTF-8?Q?Muhammet_Kurto=C4=9Flu?= , Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000299e1e064ed97775" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000299e1e064ed97775 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 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 >> >> >> >> >> >> >> >> --000000000000299e1e064ed97775 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Muhammet,

Thanks for suggesting symetricds commu= nity.

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 Akshay,

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@biso= ft.com.tr> wrote:
Hi,
=C2=A0You can use symetricds=C2=A0commu= nity which resolves conflicts with predefined rules on master master replic= ation
Best REgards


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

The client required the multimaster replication o= n the production environment. I want help regarding the following things:1. How to setup=C2=A0multi-master replication on postgresql ?
2. How t= o handle the conflicts regarding the writes on both masters servers=C2=A0?<= br>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:=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




--000000000000299e1e064ed97775--