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 1w5JUZ-0037eI-0p for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Mar 2026 08:21:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5JUX-00CymJ-2J for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Mar 2026 08:21:30 +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 1w5JUX-00CymA-1H for pgsql-hackers@lists.postgresql.org; Wed, 25 Mar 2026 08:21:29 +0000 Received: from mail-lj1-x233.google.com ([2a00:1450:4864:20::233]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w5JUV-0000000123F-1Z7f for pgsql-hackers@lists.postgresql.org; Wed, 25 Mar 2026 08:21:29 +0000 Received: by mail-lj1-x233.google.com with SMTP id 38308e7fff4ca-38a76ba6a78so41614881fa.0 for ; Wed, 25 Mar 2026 01:21:27 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774426887; cv=none; d=google.com; s=arc-20240605; b=fAuLQnvXxEobutqxW7ubwlXmuIxeW7lXfTYWPkd/g4PwtNtWoNiqSB0gy/RF5avJbt jW38yHbNjd6r5mzo3gq26thiY80lgtxeXeSVmiPfixFqti1KO4750YBHukUjH7yZndbC szvqX0iFn/xaq7iLG3w1+F4GynniTHxrer1eClkvlIxfOezEixnx1pOcC2xlS0s6UJ80 poutHElimzRKqy7taN3bhWZeiOmWFmpBzUxsjTfutb5SK4nVYMXBkk/HvXhepY8tUXOJ fW8XhdccpOf2p7pFON7OGLLv6znUGCrCPNDcRWttEcY/O2g9B85E3oWLyzjWNh8UPDH5 niqg== 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=vwVxe+rSXKGek88stTgYr7N1JBBZ+/hhyn7VGAZMxDE=; fh=b3pcsWNWQUfRMVax99MDG+fcdVulMUXwlfsdjVUyN9U=; b=fasoSqAta1ZkBbZzCrkTtBVuvvEFQFlkD9W+SMzMxfDuFebXJ8juCUrTy0r6fYEntH 5VoKy8/l1wK+JBW6QdVFllf1ek1w6T/BQmFjgwVXaCSMZZTha8p6JAXzSLkymDE86x62 aa8HYaUAuKXPRXZd5ALcbQrv4shQhFuqXC0ENjgmPFZEhjL7g6ME8UONkWH99vSVWEpB RyJVEEAjUyOhZDSs4CBUIYc1mM7CPMo7uQDJ/yA0PlTJMLErWUnDL6lV2c3KZKOFSnZd m/0ghTMCcEwz0Nkf4dxr+MkzHjTHYnvI5Bc659eHM7MNFIUPkgEc2jSbudTpbDwHZB6A PHAw==; 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=1774426887; x=1775031687; 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=vwVxe+rSXKGek88stTgYr7N1JBBZ+/hhyn7VGAZMxDE=; b=hgV68brRI5c4iTr6hwiu3LL+7w8DVCeZyCNpZEEb+nBQPeBbLNbY8QE5/A9euukjxD 3lkSnseW6U2/ghvJI5HzjBANkGAkgCe64hniY4qUhAwmLolDESFbx0BjDXQu9FI7b2vA CYKAGz7mkqcIEjPYW+GcE7y3i1mfDb6b9TiCuRYqlmMPzgCRNB20QNKYt1YgZzS00PRp LCsK6O1wfHbmNy96a9L/MqElICPHp4oNZYxrkuUulC4kSs2inPbfeAwCmnkRixeteiYX H0weAyqgAIBDvytXPK0kzWAt55YNKQxnGUC1ECjJFfN8dJ9HP7dj/LAYCgM+okWvub6+ J2Ag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774426887; x=1775031687; 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=vwVxe+rSXKGek88stTgYr7N1JBBZ+/hhyn7VGAZMxDE=; b=hV555Pt0skmB5lhhMtRXgMg6Gu0ut+AVcu3AISNQPSLbkMUO86yv0Sto68Haoos6tp Ht/QB+uhusj9AifZ8RKmHC/WyzOIAZeQOSCos6AhJfRBKJ3T0c9SKHNuOca7ycNNVmsr 1886XpxbqBuTHdifGYvIlLnMKyFIfjzMEyzKfB0chIze8IGcaMV/qdEfaizEV5Nm/R3W rxrqWDq9KPd7wT+TztBCtWOVhJVncN8/0d5KB5LTPQmi+0/X+vzR4PZSgCrjPsx4XAEO 89Bw9rqnSYUJ+rJAl3eOgXZCDseYHI9I13cLh4I4kneOpBOpogYS7jJ4NAzuey+poinj u1kA== X-Forwarded-Encrypted: i=1; AJvYcCVyUkucr2SjW4j19AGRTTYD/YIDYpTBJC3j8tM46cZUFYScOI7v59iPO+WQ/IaSvNk2yIh1Fvia4H8bMykQ@lists.postgresql.org X-Gm-Message-State: AOJu0YxujGe1lnS5+wVbbQwJOcViOUU35P6qiA1WkDbbCF2UhDcC0bX5 feOBsvu93D7Kz7O0csXpiAvSx1atB9biiV95shs9i16BpykpxCq4G5IoURGE7+wTf6/X5RxvE0A J+8dXznZqUelYiaFeV9WXZe0NuNPY9U0= X-Gm-Gg: ATEYQzzb8AKp9rHaUp5Iilc3t1P3IhWxGEOljHKqTMyozsWooGdr90vIQVDRwpIEleR sZqFo7EUMzVnyiK0v/954KxjsdKqjl9qTMI4ApAP9NWYgLiGSOfIXVuQFq+dQpaktpZG+qi6hhd UHyZX6P+aqcKJuw8feXaVr148GLTwu9aBe60VhvU7CXIaKuuS3wQyEq8o/BcNIo8FQOSqQHoA4A cdUQbQ+VYc+FaU/sQCO+UN9fq/fNg1D/smPH5Rwiu3hhRtr0JYSqvuonH/fuGxTfrXCh4sDwa7k MoTaDpCu9hzhf37x+bPz86mbQqgNfEXpdDtml8I= X-Received: by 2002:a2e:a104:0:b0:38a:4de2:85d7 with SMTP id 38308e7fff4ca-38c4307be04mr8828461fa.3.1774426886172; Wed, 25 Mar 2026 01:21:26 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Wed, 25 Mar 2026 13:51:14 +0530 X-Gm-Features: AQROBzAO9fLnPygNjb2a9YxNxKHoFzy_Vm7UtPZmYgOYZozmzNpZ0hkKdrX_RIw Message-ID: Subject: Re: [Patch] add new parameter to pg_replication_origin_session_setup To: shveta malik Cc: Heikki Linnakangas , "Hayato Kuroda (Fujitsu)" , "pgsql-hackers@lists.postgresql.org" , "Zhijie Hou (Fujitsu)" , Doruk Yilmaz Content-Type: multipart/mixed; boundary="0000000000003b0da4064dd4f483" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003b0da4064dd4f483 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Feb 11, 2026 at 5:09=E2=80=AFPM shveta malik wrote: > > On Wed, Feb 11, 2026 at 3:41=E2=80=AFPM Amit Kapila wrote: > > > > > > I see your point but one advantage with the proposed code change is > > that it started to appear that we can extend this part of code easily > > in the future as it separates most of the handling related to when a > > user has given acquired_by parameter's value as zero and non-zero. > > Okay, yes. So I am okay with it. The slight change I suggested (if to > else-if) and a comment will make it more clean. > I have tried to address both your suggestions in the attached. See, if this looks okay to you now? --=20 With Regards, Amit Kapila. --0000000000003b0da4064dd4f483 Content-Type: application/octet-stream; name="v2-0001-Simplify-replorigin_session_setup.patch" Content-Disposition: attachment; filename="v2-0001-Simplify-replorigin_session_setup.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_mn5rswr10 RnJvbSA0OTRiMzFlNzlkY2UyYTA4ZmI1NmNlZTJiNmFmNTIxMjQyYmUwNDNmIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBBbWl0IEthcGlsYSA8YWthcGlsYUBwb3N0Z3Jlc3FsLm9yZz4K RGF0ZTogV2VkLCAyNSBNYXIgMjAyNiAxMzo0Mjo1MiArMDUzMApTdWJqZWN0OiBbUEFUQ0ggdjNd IFNpbXBsaWZ5IHJlcGxvcmlnaW5fc2Vzc2lvbl9zZXR1cCgpCgotLS0KIHNyYy9iYWNrZW5kL3Jl cGxpY2F0aW9uL2xvZ2ljYWwvb3JpZ2luLmMgfCA3OCArKysrKysrKysrKysrKy0tLS0tLS0tLS0K IDEgZmlsZSBjaGFuZ2VkLCA0NiBpbnNlcnRpb25zKCspLCAzMiBkZWxldGlvbnMoLSkKCmRpZmYg LS1naXQgYS9zcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9sb2dpY2FsL29yaWdpbi5jIGIvc3JjL2Jh Y2tlbmQvcmVwbGljYXRpb24vbG9naWNhbC9vcmlnaW4uYwppbmRleCAyNmFmZDhmMGFmOS4uMjZj MzcyNWFhNjggMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvb3Jp Z2luLmMKKysrIGIvc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vbG9naWNhbC9vcmlnaW4uYwpAQCAt MTE4Niw1NSArMTE4Niw2OSBAQCByZXBsb3JpZ2luX3Nlc3Npb25fc2V0dXAoUmVwbE9yaWdpbklk IG5vZGUsIGludCBhY3F1aXJlZF9ieSkKIAkJaWYgKGN1cnN0YXRlLT5yb2lkZW50ICE9IG5vZGUp CiAJCQljb250aW51ZTsKIAotCQllbHNlIGlmIChjdXJzdGF0ZS0+YWNxdWlyZWRfYnkgIT0gMCAm JiBhY3F1aXJlZF9ieSA9PSAwKQorCQlpZiAoYWNxdWlyZWRfYnkgPT0gMCkKIAkJewotCQkJZXJl cG9ydChFUlJPUiwKLQkJCQkJKGVycmNvZGUoRVJSQ09ERV9PQkpFQ1RfSU5fVVNFKSwKLQkJCQkJ IGVycm1zZygicmVwbGljYXRpb24gb3JpZ2luIHdpdGggSUQgJWQgaXMgYWxyZWFkeSBhY3RpdmUg Zm9yIFBJRCAlZCIsCi0JCQkJCQkJY3Vyc3RhdGUtPnJvaWRlbnQsIGN1cnN0YXRlLT5hY3F1aXJl ZF9ieSkpKTsKKwkJCS8qIFdpdGggYWNxdWlyZWRfYnkgPT0gMCwgd2UgbmVlZCB0aGUgb3JpZ2lu IHRvIGJlIGZyZWUgKi8KKwkJCWlmIChjdXJzdGF0ZS0+YWNxdWlyZWRfYnkgIT0gMCkKKwkJCXsK KwkJCQllcmVwb3J0KEVSUk9SLAorCQkJCQkJKGVycmNvZGUoRVJSQ09ERV9PQkpFQ1RfSU5fVVNF KSwKKwkJCQkJCSBlcnJtc2coInJlcGxpY2F0aW9uIG9yaWdpbiB3aXRoIElEICVkIGlzIGFscmVh ZHkgYWN0aXZlIGZvciBQSUQgJWQiLAorCQkJCQkJCQljdXJzdGF0ZS0+cm9pZGVudCwgY3Vyc3Rh dGUtPmFjcXVpcmVkX2J5KSkpOworCQkJfQorCQkJZWxzZSBpZiAoY3Vyc3RhdGUtPnJlZmNvdW50 ID4gMCkKKwkJCXsKKwkJCQkvKgorCQkJCSAqIFRoZSBvcmlnaW4gaXMgaW4gdXNlLCBidXQgUElE IGlzIG5vdCByZWNvcmRlZC4gVGhpcyBjYW4KKwkJCQkgKiBoYXBwZW4gaWYgdGhlIHByb2Nlc3Mg dGhhdCBvcmlnaW5hbGx5IGFjcXVpcmVkIHRoZSBvcmlnaW4KKwkJCQkgKiBleGl0ZWQgd2l0aG91 dCByZWxlYXNpbmcgaXQuIFRvIGVuc3VyZSBjb3JyZWN0bmVzcywgb3RoZXIKKwkJCQkgKiBwcm9j ZXNzZXMgY2Fubm90IGFjcXVpcmUgdGhlIG9yaWdpbiB1bnRpbCBhbGwgcHJvY2Vzc2VzCisJCQkJ ICogY3VycmVudGx5IHVzaW5nIGl0IGhhdmUgcmVsZWFzZWQgaXQuCisJCQkJICovCisJCQkJZXJl cG9ydChFUlJPUiwKKwkJCQkJCShlcnJjb2RlKEVSUkNPREVfT0JKRUNUX0lOX1VTRSksCisJCQkJ CQkgZXJybXNnKCJyZXBsaWNhdGlvbiBvcmlnaW4gd2l0aCBJRCAlZCBpcyBhbHJlYWR5IGFjdGl2 ZSBpbiBhbm90aGVyIHByb2Nlc3MiLAorCQkJCQkJCQljdXJzdGF0ZS0+cm9pZGVudCkpKTsKKwkJ CX0KIAkJfQotCi0JCWVsc2UgaWYgKGN1cnN0YXRlLT5hY3F1aXJlZF9ieSAhPSBhY3F1aXJlZF9i eSkKKwkJZWxzZQogCQl7Ci0JCQllcmVwb3J0KEVSUk9SLAotCQkJCQkoZXJyY29kZShFUlJDT0RF X09CSkVDVF9JTl9VU0UpLAotCQkJCQkgZXJybXNnKCJjb3VsZCBub3QgZmluZCByZXBsaWNhdGlv biBzdGF0ZSBzbG90IGZvciByZXBsaWNhdGlvbiBvcmlnaW4gd2l0aCBPSUQgJXUgd2hpY2ggd2Fz IGFjcXVpcmVkIGJ5ICVkIiwKLQkJCQkJCQlub2RlLCBhY3F1aXJlZF9ieSkpKTsKKwkJCS8qCisJ CQkgKiBXaXRoIGFjcXVpcmVkX2J5ICE9IDAsIHdlIG5lZWQgdGhlIG9yaWdpbiB0byBiZSBhY3Rp dmUgYnkgdGhlCisJCQkgKiBnaXZlbiBQSUQKKwkJCSAqLworCQkJaWYgKGN1cnN0YXRlLT5hY3F1 aXJlZF9ieSAhPSBhY3F1aXJlZF9ieSkKKwkJCQllcmVwb3J0KEVSUk9SLAorCQkJCQkJKGVycmNv ZGUoRVJSQ09ERV9PQkpFQ1RfSU5fVVNFKSwKKwkJCQkJCSBlcnJtc2coInJlcGxpY2F0aW9uIG9y aWdpbiB3aXRoIElEICVkIGlzIG5vdCBhY3RpdmUgZm9yIFBJRCAlZCIsCisJCQkJCQkJCWN1cnN0 YXRlLT5yb2lkZW50LCBhY3F1aXJlZF9ieSkpKTsKKwkJCS8qCisJCQkgKiBIZXJlLCBpdCBpcyBv a2F5IHRvIGhhdmUgcmVmY291bnQgPiAwIGFzIG1vcmUgdGhhbiBvbmUgcHJvY2VzcworCQkJICog Y2FuIHNhZmVseSByZS11c2UgdGhlIG9yaWdpbi4KKwkJCSAqLwogCQl9CiAKLQkJLyoKLQkJICog VGhlIG9yaWdpbiBpcyBpbiB1c2UsIGJ1dCBQSUQgaXMgbm90IHJlY29yZGVkLiBUaGlzIGNhbiBo YXBwZW4gaWYKLQkJICogdGhlIHByb2Nlc3MgdGhhdCBvcmlnaW5hbGx5IGFjcXVpcmVkIHRoZSBv cmlnaW4gZXhpdGVkIHdpdGhvdXQKLQkJICogcmVsZWFzaW5nIGl0LiBUbyBlbnN1cmUgY29ycmVj dG5lc3MsIG90aGVyIHByb2Nlc3NlcyBjYW5ub3QgYWNxdWlyZQotCQkgKiB0aGUgb3JpZ2luIHVu dGlsIGFsbCBwcm9jZXNzZXMgY3VycmVudGx5IHVzaW5nIGl0IGhhdmUgcmVsZWFzZWQgaXQuCi0J CSAqLwotCQllbHNlIGlmIChjdXJzdGF0ZS0+YWNxdWlyZWRfYnkgPT0gMCAmJiBjdXJzdGF0ZS0+ cmVmY291bnQgPiAwKQotCQkJZXJlcG9ydChFUlJPUiwKLQkJCQkJKGVycmNvZGUoRVJSQ09ERV9P QkpFQ1RfSU5fVVNFKSwKLQkJCQkJIGVycm1zZygicmVwbGljYXRpb24gb3JpZ2luIHdpdGggSUQg JWQgaXMgYWxyZWFkeSBhY3RpdmUgaW4gYW5vdGhlciBwcm9jZXNzIiwKLQkJCQkJCQljdXJzdGF0 ZS0+cm9pZGVudCkpKTsKLQogCQkvKiBvaywgZm91bmQgc2xvdCAqLwogCQlzZXNzaW9uX3JlcGxp Y2F0aW9uX3N0YXRlID0gY3Vyc3RhdGU7CiAJCWJyZWFrOwogCX0KIAotCi0JaWYgKHNlc3Npb25f cmVwbGljYXRpb25fc3RhdGUgPT0gTlVMTCAmJiBmcmVlX3Nsb3QgPT0gLTEpCi0JCWVyZXBvcnQo RVJST1IsCi0JCQkJKGVycmNvZGUoRVJSQ09ERV9DT05GSUdVUkFUSU9OX0xJTUlUX0VYQ0VFREVE KSwKLQkJCQkgZXJybXNnKCJjb3VsZCBub3QgZmluZCBmcmVlIHJlcGxpY2F0aW9uIHN0YXRlIHNs b3QgZm9yIHJlcGxpY2F0aW9uIG9yaWdpbiB3aXRoIElEICVkIiwKLQkJCQkJCW5vZGUpLAotCQkJ CSBlcnJoaW50KCJJbmNyZWFzZSBcIm1heF9hY3RpdmVfcmVwbGljYXRpb25fb3JpZ2luc1wiIGFu ZCB0cnkgYWdhaW4uIikpKTsKLQllbHNlIGlmIChzZXNzaW9uX3JlcGxpY2F0aW9uX3N0YXRlID09 IE5VTEwpCisJaWYgKHNlc3Npb25fcmVwbGljYXRpb25fc3RhdGUgPT0gTlVMTCkKIAl7Ci0JCWlm IChhY3F1aXJlZF9ieSkKKwkJaWYgKGFjcXVpcmVkX2J5ICE9IDApCiAJCQllcmVwb3J0KEVSUk9S LAogCQkJCQkoZXJyY29kZShFUlJDT0RFX09CSkVDVF9OT1RfSU5fUFJFUkVRVUlTSVRFX1NUQVRF KSwKIAkJCQkJIGVycm1zZygiY2Fubm90IHVzZSBQSUQgJWQgZm9yIGluYWN0aXZlIHJlcGxpY2F0 aW9uIG9yaWdpbiB3aXRoIElEICVkIiwKIAkJCQkJCQlhY3F1aXJlZF9ieSwgbm9kZSkpKTsKIAog CQkvKiBpbml0aWFsaXplIG5ldyBzbG90ICovCisJCWlmIChmcmVlX3Nsb3QgPT0gLTEpCisJCQll cmVwb3J0KEVSUk9SLAorCQkJCQkoZXJyY29kZShFUlJDT0RFX0NPTkZJR1VSQVRJT05fTElNSVRf RVhDRUVERUQpLAorCQkJCQkgZXJybXNnKCJjb3VsZCBub3QgZmluZCBmcmVlIHJlcGxpY2F0aW9u IHN0YXRlIHNsb3QgZm9yIHJlcGxpY2F0aW9uIG9yaWdpbiB3aXRoIElEICVkIiwKKwkJCQkJCQlu b2RlKSwKKwkJCQkJIGVycmhpbnQoIkluY3JlYXNlIFwibWF4X2FjdGl2ZV9yZXBsaWNhdGlvbl9v cmlnaW5zXCIgYW5kIHRyeSBhZ2Fpbi4iKSkpOworCiAJCXNlc3Npb25fcmVwbGljYXRpb25fc3Rh dGUgPSAmcmVwbGljYXRpb25fc3RhdGVzW2ZyZWVfc2xvdF07CiAJCUFzc2VydCghWExvZ1JlY1B0 cklzVmFsaWQoc2Vzc2lvbl9yZXBsaWNhdGlvbl9zdGF0ZS0+cmVtb3RlX2xzbikpOwogCQlBc3Nl cnQoIVhMb2dSZWNQdHJJc1ZhbGlkKHNlc3Npb25fcmVwbGljYXRpb25fc3RhdGUtPmxvY2FsX2xz bikpOwotLSAKMi41Mi4wLndpbmRvd3MuMQoK --0000000000003b0da4064dd4f483--