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 1wWTAa-002dXu-1N for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jun 2026 06:09:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wWTAZ-000xoe-1G for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jun 2026 06:09:07 +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 1wWTAZ-000xnb-0L for pgsql-hackers@lists.postgresql.org; Mon, 08 Jun 2026 06:09:07 +0000 Received: from mail-dl1-x1233.google.com ([2607:f8b0:4864:20::1233]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wWTAW-00000001duS-2vfw for pgsql-hackers@postgresql.org; Mon, 08 Jun 2026 06:09:06 +0000 Received: by mail-dl1-x1233.google.com with SMTP id a92af1059eb24-138129a622dso5211677c88.0 for ; Sun, 07 Jun 2026 23:09:04 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1780898943; cv=none; d=google.com; s=arc-20240605; b=h0QvSXI+KZXeDHbJFej9zR2FOO8/iLM1mmVtZriWBT2AkL1iT2c7x1j7w7u7nhrOkI OzjGhtF6JWI7HefBJCM7IHaaOjtYuk3TMxGUwmDl+3RoQF5sOIKfjRgcIS4FBWPiU94I FU+QVG85bkfj8TWeDD5kMk4eD+H98M8d760sTSeB5AodZRBE/yng8sdaHcsql3Q74A/Y +AqNaBvq3DA5dgfW/NPZXPl24mzLLYh6pHmtzvsn/z1k5LptQ7rk3uPC4BbkmJa1ryWN px57iPxnCa5Qu+HHFKhya3PU70l/YHk3YNWdbrR42d/wb2u98WCoAL7t6YYtTOMfmzJo ZteQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=yMzAKJk9xgeUuK+uOxkePKkEIq9/LDLv1PW0OT5iY4M=; fh=dvqdS8qvtqLSPhepyFQOV93ecApwcugL/9xFu+MWHdE=; b=WL/ebJy4mm6TBy8rHIh24UCEArSgwndfjLJhz1jrAcFEMtC+kEgMeNvyxug8BV8osF SgIL4xOcxx7rt2Y47l9xmr4oBaDeTll9YMJualCz1uN7UEZ1l7wlwRccygA8dnzeCq3M UZ8LYDdsQzQABnQMfb2WSRjw/WWdaHr5FrEsuXJB//TNw+jhwicxv9WQdXOCSm/sPQJs Jo3OzIz3eZoHXWn2DETCHyq5Zu694CHITlPuJ/Wlluf31MpkHiA2trgGvmGHuyzs5Jj4 lzoJ3Rvc3u3joOd5DFj7bVWzkcUrDHcu3Q8ufqLNr1Jcegf25Js+ZVHEJKgGFQGMIUVJ 2kFQ==; darn=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=1780898943; x=1781503743; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=yMzAKJk9xgeUuK+uOxkePKkEIq9/LDLv1PW0OT5iY4M=; b=KO1vbrwjI+m/+A8/IBVIOZcpYPGnCs0KSj66hldDif6nnrjPckSWDy54rx/b7NEqDH fl5APq+YkgXDAXrC1EyLdmgMHhdDmiczxSdEE+dQ7GfUzdKIV19wIsBSUCzFQnvCX68s 9zqpYDWjwjUV1Bu0Av1tunY2bfcnqZGEjoQ7EgLZLBO6CPhp1diTh8cvS62im2ox+1pG N4u1lL124HRdEPYkBzTaS7l5C4TdrEc1xEzdRS3ObobXqaQBz/BBOdxkiZs8/uDaQG2j ZaxoK1jm0BiilwbNcA34EiN4WYEzVKntXnLz46TPXPPS/Af77O3SzPIEDCgzsGGHNhw0 LbKw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780898943; x=1781503743; h=content-transfer-encoding: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=yMzAKJk9xgeUuK+uOxkePKkEIq9/LDLv1PW0OT5iY4M=; b=pRZBLFwFGD4x/42K77tTvuz5H/XYdtsKU3IxJ1aoWrAP8+F74BIwS29nZaRXSVRuv6 zERVpBpBwCsKlwTunrM2FvvOfQlV+mVE6QRllyCAkYFeesgFbUjdR/jOHkXyoGhdsGlH cw0qGlfTtgch92l4TMcbEmuAcR3hp5c+HFEEEW7vodU/YVoE1XUm+HWxdFFbDrIITvRd /3o7d3BCW/R67RoZY6TZzvYU6FDp8qGvWuEeeT5hngKEVtR4Z9wexaVWsR16AW/XpkE1 RxvgdMcWZHkYsJ577f7BLlLpEBG5Nr8bPUW3+eWLEBr+buouiAwHQCVLfOu/N2RAeAc4 Ujsw== X-Forwarded-Encrypted: i=1; AFNElJ+392wPvsQr5JWW57TuGlYxR/OH+4dcSXpeb0W2oAdV/ckDXidLJNHG5IxESd1TYD+DoGzLm6uH1Th3h4TX@postgresql.org X-Gm-Message-State: AOJu0YyZpphIeeFap2f2o5/MwEKKEdjEzzkLcgAbr5g1gzZaSvQt1uke itDcMhFzNJEmNbaTkUivHLKIi5DJQQ/fwimUGYNorhlrb5p8WswuhXEP5CT0Rm5kgjjc+yQGGi/ bVN6kgcD6zWUAjw4YQmrwSFegqSMTqNU= X-Gm-Gg: Acq92OE7N+ABiccw7MKrPLNcY3s7mA8sdXm6TJBxp6M7jLMdxgpikoVIjGqRyFqydam J/vYBeDEsFYfVaeqNQ1OX9SZQymmpL3DI8V3b1PoEJwWpoOTF+2W0H5nFbDZ5vFGD96uumi3uZc 8zCLWunrtNOs5Lcyt2IYMXRP9POSbHARa4tCb9lP7TGSWOHmdwx6iPky0VGYBjH07LwIsg/pkTl GVcBX636mAlEy5nbYm6mDusvS0I8u1KhpPP/7SEVcrwQHYy0/B3mgHMP4Q2og5z+Kh8nWHru0Iq WBwGH76uRvj4GwtGbQwp X-Received: by 2002:a05:7022:1a83:b0:12d:d972:b96e with SMTP id a92af1059eb24-1380670f684mr6942167c88.20.1780898942959; Sun, 07 Jun 2026 23:09:02 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ashutosh Sharma Date: Mon, 8 Jun 2026 11:38:48 +0530 X-Gm-Features: AVVi8CdxNlcsnb3Xc7yyn_KI5lmqim5abqXTK5yO19Glk-ceKcB3daAGuOg7RIw Message-ID: Subject: Re: synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication To: shveta malik Cc: "Zhijie Hou (Fujitsu)" , Amit Kapila , Ajin Cherian , SATYANARAYANA NARLAPURAM , PostgreSQL-development , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On Fri, Jun 5, 2026 at 3:32=E2=80=AFPM shveta malik wrote: > > On Thu, Jun 4, 2026 at 2:57=E2=80=AFPM Ashutosh Sharma wrote: > > > > > > So my preferred behavior would be: > > > > 1) duplicate names: normalize, do not error > > 2) after normalization, if num_sync > unique_slots: error immediately > > > > Thanks for tha pathces. I have attached a patch (txt file) with a few > trivial changes, take it if you find the changes acceptable. > Thanks, I will review it and share my feedback. -- With Regards, Ashutosh Sharma.