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 1w9dOh-001bXg-2q for pgsql-admin@arkaria.postgresql.org; Mon, 06 Apr 2026 06:25:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w9dOg-006tZI-0J for pgsql-admin@arkaria.postgresql.org; Mon, 06 Apr 2026 06:25:18 +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 1w9dOf-006tZ9-2Q for pgsql-admin@lists.postgresql.org; Mon, 06 Apr 2026 06:25:18 +0000 Received: from mail-yx1-xb131.google.com ([2607:f8b0:4864:20::b131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w9dOd-00000000rAJ-3e5N for pgsql-admin@lists.postgresql.org; Mon, 06 Apr 2026 06:25:17 +0000 Received: by mail-yx1-xb131.google.com with SMTP id 956f58d0204a3-64937edbc9eso2993712d50.2 for ; Sun, 05 Apr 2026 23:25:15 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775456713; cv=none; d=google.com; s=arc-20240605; b=ODkzxu/zDt58Wt1FxGMEm7KpXkpaeIWvYbkpvTlhuvuZXAFzfWKxVFoL2tKesVmKVU o2J7wauUF0G0Akw299I4KRqJBs2AIfs2VrCM9DoYlEzYg4MwD3fkqIG7aCTr8NhwVxG/ lOjIImrvdXCcEW8dleEngrN5D7IUWC+pVkIrhEIkHGfHDGKdCaC7hySkRhHq7cUiukFU LqsfKfXiGVstRi+oV1p8A6vkLDMnmye/VGWHFmPUrTH6KRjGo83kP0ExGFNlb4syUruX GPbtdMV7077xWf5VEldeqOgj3+7excRS68gDZkm2Vnz4CXoEGrQeBNjdWkDkwdOU9UCa dc1A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=ct1XlZ9DoM9tr5uQKtU+KwdN+OoBtZxP10X5IHEi6/c=; fh=druxZHa2fk4e6MLibibygn9AWWgeaAPo4m8Gpo2MBXU=; b=RtWX70SlTlElNTd6CvA819AJ3aoIDaZnTFRAUwzvz60FmHKaJtGWVWGqetUtNgrs+1 HmdtHb+5aVqOMAGcGs+a3t9LeaU3fsZadEPVtQqMvqAF86PgoSfjt+CAZAf+szraUmng 5jT2z1eVoy2Ai/8W886TEPDfLwiiO9ItRNbIIVs0zCcWN+KMokG2D9hO1RikfxREJt1s EUDJvGHmVNWvwjvPY7bcKU8I1RuCxZE+KYeDRA7aHhYCbkdEedqoUYR07bq+wPV/44Ng AMWmz8FZbkH2hmkI/D3FU3T9dYFpUaHolVy8ZCdTDMKJWPHFpWYo44DBMvMJt8llIbY1 ePWg==; 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=1775456713; x=1776061513; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=ct1XlZ9DoM9tr5uQKtU+KwdN+OoBtZxP10X5IHEi6/c=; b=k1gyB/eDSoPVXWRtP+m+BHKIgd/e3t0u4X54fvJGg342pUctZnha4/DvJQ4eB/vf85 JdwjulvCxx1HkEspfUJxevrS8y0g6xf+NbXNG48gl/T9J1+h8+DfZGkK08ckHDv2y0Un 3RNqdMyviV1SFTLfHWjAzaTrWvO2WWF9KkH78yksZF1QG0LKq31rwXDmhK0bKR990eM0 P5BO+ykX2k39ZablHyTn0f12FWPdz2kDOsQ2LnH+D34422jlVTZJ8R22rp3O3tlhBXS+ IKzh59hgBmn8MKLLjm3Ox/jPhg5ZdUSLp3xBcUsx+hB4Z9RpSdDM8i6c9Fk/OiqxIU4g SAPQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775456713; x=1776061513; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=ct1XlZ9DoM9tr5uQKtU+KwdN+OoBtZxP10X5IHEi6/c=; b=mVt3kX4022qx4uUl29MHkRxv0UkjcvHg4e5Kdmv5vVDmvMtI8E7LXqoA9U2lhiNh+k euvLSZj3DkE3w14oK5siv1QZ2eq5Q+dllwQs3z0kGUNZl5/7wKe9QZS3AiynMyF6yeLS RpZJcGdDyMdk/oLirnFEg9qMJjeKpJ09rSc4W7D2alN1d3dpVqPf4NvP4nULsSdmSSzU bWP+dTWg5M3IdRBdW7VpsSzseIsX1+EIBQLXB4D4Pjh/DioHmgq3bAsIAqcWe8ijSrrT C+FLLuEhAbhBlvOkeYCEoFtxcKKq26juqwsywFXs12LEDC/0bfbJXyiGgwpPrK+QrDMf TI2A== X-Gm-Message-State: AOJu0Yy85E4HbxCuEHpau4vpC6+yDGBhXfGnF8CqlFcAI+xNBkRHv29G fa4DUMKBfTOdYdrypzK4R1PoSfQ1KL4Nj7Kfzgw+DzHSbI9AOK2X/Qm/cX8gWEnWBEcSsDhEpyl jmUZqzaz+PgNQxlEG+yqIo3foaYFCw84dQg== X-Gm-Gg: AeBDietmdJAn9A4VO3RI8HSoIhAgAh5rmAo4hIeUPdRYRUf7fZrclGhwxF5/3igfGly cyLqWMO26HrzNAJWCyL2dNI9XlbPrQ1TcAgNZ76DjPYNcNpjBMh/nTHf6XeJO2po3k1KpRiTzWx IDa4A1S3uKNK9J4SjIMeS+sZSqtqLRJ2sG06wgty8ac/A1RgtHQRgWbX9N265El23Ej2FSBcgUI InifLNjT/6iUhjlG3cxjzzARhehwourR1VjbpgFyWlejEp0GNIvGPq5V955n0rh5GAVefyDnB4B l4FeF0KshQ== X-Received: by 2002:a53:d00a:0:b0:650:1bc2:7de2 with SMTP id 956f58d0204a3-65048707c70mr11020627d50.21.1775456713310; Sun, 05 Apr 2026 23:25:13 -0700 (PDT) MIME-Version: 1.0 From: akshay chandratre Date: Mon, 6 Apr 2026 11:55:02 +0530 X-Gm-Features: AQROBzDrQZmZ7mchXk3qHD67A82keBnYlPYK_hPLvoGV61UiikKmg1Zwu0jlcv0 Message-ID: Subject: How to setup Multi-master replication on postgresql 18 To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000b60604064ec4bac2" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b60604064ec4bac2 Content-Type: text/plain; charset="UTF-8" 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... --000000000000b60604064ec4bac2 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Everyone,

The client required the multimaster re= plication on the production environment. I want help regarding the followin= g things:
1. How to setup=C2=A0multi-master replication on postgresql ?<= br>2. How to handle the conflicts regarding the writes on both masters serv= ers=C2=A0?
3. Is it reliable for production ? Any other suggestions or o= ptions for multimaster ?

Postgresql V18
Os: centOS

=
Thanks in advance...
--000000000000b60604064ec4bac2--