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 1w9e5L-001c4P-26 for pgsql-admin@arkaria.postgresql.org; Mon, 06 Apr 2026 07:09: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 1w9e5I-0072EB-2M for pgsql-admin@arkaria.postgresql.org; Mon, 06 Apr 2026 07:09:21 +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 1w9e5I-0072E3-0L for pgsql-admin@lists.postgresql.org; Mon, 06 Apr 2026 07:09:20 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w9e5G-00000000oaf-0dFX for pgsql-admin@lists.postgresql.org; Mon, 06 Apr 2026 07:09:19 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-b9c0e05d913so80411166b.1 for ; Mon, 06 Apr 2026 00:09:17 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775459356; cv=none; d=google.com; s=arc-20240605; b=KwmhwehnfPRYq4Q8aueN24XGI5uKEtg1JbYb6hS698ri/VW1KEOBSId2noxzVUubQM WzioSVnTAGF7dmtx5sX26wOSQvVTlhPljkDkI3BS54Z3R5YwrK8ZW1Xe3NVsP646F578 7/v/PBP+C5Y6qt27erdwmzE0R9d1Giurb1BJq4VgAp03brWPxZJLHlg47vUkaAa9Gyb9 TomaPax3sAGsFC0gAGVu7r3N07nWP8XVjYep5KnT5rxmZ9nwyzLTpjHgKrgoebROvjCX DiYQYl0YQSFeFsGPTsNGsiZ4vmDG9AOLkwA+Usz7nNp3S47qnbNd2bcY942Jbm0pFBhj 7egg== 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=h5gphjK4Vr6MSa9OQqF1/oItlUkev2ECnK0KQzHJV+g=; fh=CoWCZ9WjOHMjKveD7YbUTkyVh34zH0q8PsJbTSJAbp0=; b=A2cIaFnkWH02GR8XBTA1pvjjvdWJ1D7P8XNzKeVjebj5PgbOsWlvkHmzOzpeA9ha1x Yqfgo7Rn6dK/3q38/4aMimhii79o7dK/TcuP93JI32MgA+rfrf87g+Sqds4ce+d3mFjh dNCUBteTGVrkTAUOieHcRryn4qmXwnyS26TOua2e3Z7x1hUvtGbH9rbFGFrf2T3cayza ek3bZVLvc6P0oJ+iEHo6Sw4WLvjsUjjSzEjLLXbckxMx+OysHmbZsoSnsiB1nTZp2D75 JaBGZxuthZwCOKgn/brmQA9Gsue2a49DqjsOlZVxm7JxKrWx19xAc5KXb73BRpPz8x60 mWSA==; 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=1775459356; x=1776064156; 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=h5gphjK4Vr6MSa9OQqF1/oItlUkev2ECnK0KQzHJV+g=; b=CSPjWNytfeJTcZmpmQATGwfbm1ZBU8JYZDFLWPXp0ETCy11/CoJwIBeLK4Ca5V9msK f/AP/lC0We/w/+3/lUXG+1imrDl70OsponVRm9Jj81rPob5AanE9bK+++XKk4bU+dwcB pWuRdnM9U2RUtAio3MLdf+y5CiSMr+u3WYl7THRp4IEajkVhi/5laYvytqVz+F5elr1L 0oSHeWpDxcaNbd1uK7vNrlNlogGssdAVTmH1KMgBmCaG8rr5hCMl4JFdVYGx4u9koerD iYvNL3Ivfd2bGFG0yLv6PRAAh2atjqJNZ+kU31ZVZV6O6PDwzvvkZ/62FCuHZB7r7qsc Y8OQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775459356; x=1776064156; 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=h5gphjK4Vr6MSa9OQqF1/oItlUkev2ECnK0KQzHJV+g=; b=i8i/t2/EDYxWLEeOj3Qz6lBzi3JM+Ro2ypoMtLpWE0xDKfwj0edr1jGagBDZprXZlW +ErIphURnHrC8m5TL8sKRiiHoydgYX4U9njCAgrdLCfDV2Zixf/1m2JDHirAvitfr0Fz GG8jsw5V98EIJ5SH0CmIvcoWuRqdExKpZSIHCZonIDn1H9kGRGUMh6GtY492Jcrz6ZQ0 L7u4M5KZi6J/WYi68PPY9gKgVrl+C7O1xTjFBx7rD++/rWzHfyDfSRueuuWD+gNOGoXZ dghc2GwLBx1afEtBuO5HCysEgzDgRrr+U4vlnSZGKgf1seuDbHX8POtuchMZJiSZRIS5 w5LA== X-Gm-Message-State: AOJu0YzZRD5XnufpfYxCw2wmGxy0ll3bZy80UgEgHT+MbTNbC4zWG85s fCPRb3BErPz5c4qintV6DvMmpAeMRKMnVeO/h7AwT/L3O5qkGGtHA5xFVnuW+wMlE/VSuEX8sNM rcDvtgYdkoQg9cS3mXYHE4ygiyaEEdxV9/wErtClUkS3R8Iu2WNfO/j2xgw== X-Gm-Gg: AeBDies4WGoyZ8kgidoTywSmfj8KRd2u1OjDje5QvbVwoBXfkku/SInZocoKZQxkeqs fPh1DXNSrouP2C8xIuSBFneIwYlb8T1eYuQIP9++dwaOiScsmJsNhcjCLXq6p+EmNDkkaB7hsJg ID1mFBfP7nNNB6VsuPjgM9f9vX0/CXeiBJI9RBC1WI9qJo69TUah5qXsV8jcLFVncHnX0C4asRq RFPFagF5o/MHMVfsbAYyb4D9B+PPZgvknviDw67uHluLs7WnrTOHXUlOLqqwreUXlNDr1LKNTKa o5i5zLI= X-Received: by 2002:a17:907:c0a:b0:b9c:131b:b011 with SMTP id a640c23a62f3a-b9c67b48d4fmr186007166b.8.1775459356093; Mon, 06 Apr 2026 00:09:16 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: =?UTF-8?Q?Muhammet_Kurto=C4=9Flu?= Date: Mon, 6 Apr 2026 10:09:04 +0300 X-Gm-Features: AQROBzACK0-CxVbjfSGSWOrgin4a2dRxPwg8XpGg5VM06uyLwJZQQD-9QW8CGLs Message-ID: Subject: Re: How to setup Multi-master replication on postgresql 18 To: akshay chandratre Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000003bc3af064ec558f1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003bc3af064ec558f1 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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... > --=20 *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 --0000000000003bc3af064ec558f1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,
=C2=A0You can use symetricds=C2=A0community which = resolves conflicts with predefined rules on master master replication
=
Best REgards


akshay chandrat= re <akshaychandratre44@g= mail.com>, 6 Nis 2026 Pzt, 09:25 tarihinde =C5=9Funu yazd=C4=B1:
=
Hi= Everyone,

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

Postgresql V18
Os: centOS

Thanks in adva= nce...


--

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




--0000000000003bc3af064ec558f1--