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 1vrvXW-00DJin-1X for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Feb 2026 10:09:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vrvWV-001Gct-18 for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Feb 2026 10:08:11 +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 1vrvUK-00130q-38 for pgsql-hackers@lists.postgresql.org; Mon, 16 Feb 2026 10:05:57 +0000 Received: from mail-lj1-x236.google.com ([2a00:1450:4864:20::236]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vruLu-00000000rDd-0JBR for pgsql-hackers@lists.postgresql.org; Mon, 16 Feb 2026 08:53:11 +0000 Received: by mail-lj1-x236.google.com with SMTP id 38308e7fff4ca-385bc6910eeso19978121fa.2 for ; Mon, 16 Feb 2026 00:53:10 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1771231989; cv=none; d=google.com; s=arc-20240605; b=YonomhXiqzGyGJ1TA4/yktgNkZoEnXXPL/aBJrhCmb+WhpEWOZr4rIw0UihsRanT0F XfLowU9pqPtRJmcj6a8vsiBJAZr/uWK/AlSEt+8KXcngQCNPySGNeJBHV4tyBd90X9Nw FG7fz1/jg25J+hRvhvdLAYheQMVh8Acp+Sf/41V1a1NtyCPIsUB6/hJZFfQhB8KJRuQQ MHfWlHROA5EMPzG82F1KEPfL3JMSn6ENdW350xn++yntQ1eCpahSJXt1nCYz2RjTS5cu hnSCTdC5MRabsFc7LpG2fQwi2G4gz6sRy/2l/zILr1LrnuoIR2uFFeIMXYHurRBS7Dpu L4Sw== 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=ny4eR7DU/f15bEYZUSIAas/H3wZQE8gW856w9GmdfXw=; fh=2+Av1fLophM3Vprf9mJDFAUs60RAUMl7SW8P6yxz8zs=; b=hRaqM13w9I11PgEymMmEsSa4AW7OAgeCoyu2QDNfNvLS+9Ewc/FZHXsD3JJZ78kSQu JDJlaFvrG3/mVXx6VRN0zs14Dq3lIQY7zZiaYRGM6fk4b4/PvnF9S9q3jQZAC9ZeMtup Y8U+daz1Lh0pcacN9aiu4twBRR7Q2KUTnaLnNPUOKH2JTO19pSijQp2cxdNoRfpRTjAR B3wo6rMcem8Qx5tVwhV2lE8DB16r14amJHwTBf1ALinFicRC8gd6SqMHNPondh5ynLbW sD7VzZ7q2V4lu/PAHkq87NTCxml1MBYpAwzbfRMsyEVqzp3/96cDQOGEFp4Row9G7d2Z Y9qw==; 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=20230601; t=1771231989; x=1771836789; darn=lists.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=ny4eR7DU/f15bEYZUSIAas/H3wZQE8gW856w9GmdfXw=; b=DUphvB/4LIaoK/moKemCh1RBkQxZVrwwMJcLvyHQj+sCTFw7vD9ygjDr6149gQ2SXL TtUL7O3DHfBipEJbFajgwH52KXAHCUc3OM3p5H4Ppg8N53RvqulSs9N4pkmnTg11lvW8 JGDAfbOi13k/AqGSNLym6jBLtoJR6AYJaDw0aWGsbUZMcYopOHPg3Pv70cR6iO15N43i gla4SzIcjob0Ws/n8WQ88H0S1rj5z8lbubpiL5zsU+wiH9Bea755KL8WQSKpQmKhYjBF CdyC6rxvx+FVS8d1Bw7zITLb74dF2ikymnCUcOBRZMwMGMPPNmmb1fPHTaPYVF8lapib cyWg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771231989; x=1771836789; 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=ny4eR7DU/f15bEYZUSIAas/H3wZQE8gW856w9GmdfXw=; b=PbQHNEAkBf+qRv56+kxFfmxSTUFhRMjIo3dPj0MbW8DB45hZQ4rD6lg6sCT9hs2gQa o1y+6no44/p4wlpiFxoGsEdD8DczC8UfuKeOqgZaxiHM/DJFDMzyquje+f3/DIY10oUZ YcAavpDObHCtA80KoV0lkz5hRTeqqM1C9Zpw4JwY+2UU2eXe55dIPiVVmWeeH5eKp/bN atrk/Br2Gip1Sm08TEy073D5JwR/UxJkApQbfyU9v+pypAcO1EMeGkv3m4AbeeehE0NR hAhDo8+qh3K9CbVmg/aaRi5A58nMErsjN5DotQWQiQ8rG5nYVS/TSA0swFqOJfRlWS4A 8Q0Q== X-Forwarded-Encrypted: i=1; AJvYcCWzqcgbkosvfMIuPCeAgPj+SddcxHDYp7ssLwbnXzOOeGXDPcZOl9YR21fpJUcgZYv4PLLZ5ZTZu9spnw+F@lists.postgresql.org X-Gm-Message-State: AOJu0Yx3pH6b/BZbO68SaF+EfNQuOli8BgmKKuwF2KuAH/BeTpUIM/n+ EwTusUqPvdEgIUM0zrysWlOpvr9lLSYPz2HOWhlHsiUC68TJ/q40io9x7cRSLOT9lMHa7bIXuRY vt1NOtrHETdSvVKjXSELi8B29VAxFhRE= X-Gm-Gg: AZuq6aKmm6kJ1lVjEGcj1h/cvSoW1vHkV+g3Qeypr1D9vBRnPnf3Z7LrKFBF9SsBGLw IxkJYpj3o5cBwdso6uMDWO+N7RZ7Lk2+8+69V6/9z5i9NZsrBCQcAD+JNIw9roDH7hnQo/aUAyA vPszabqPU7WAfaRSr8mZN9ZrXueWlXtnjrqS48SpsOddng5zlrWCFxkUSIWq2/6kW4YE/nquR4s C9ta6a2ojZP5ZerwQSdbFWAsb7ziPuBl8z9QQRoiGt8OOPGBLsNjymq+9rgoqZhmqOA9hpedK0D Q3ttUZAt+ucHY3dt6b1GqsGqrL+xYyvQBOSIlM7Dx9DAEX90SIjQhHMRG+jQvQeEP1iUKo0ptg= = X-Received: by 2002:a2e:8a87:0:b0:383:f7:1064 with SMTP id 38308e7fff4ca-38810521b7dmr28337981fa.18.1771231988973; Mon, 16 Feb 2026 00:53:08 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Mon, 16 Feb 2026 14:22:57 +0530 X-Gm-Features: AaiRm50bbZefLRQ6q6s7ld-U14c-BoRG0TIy_u5oSygeQWOgT6x1WD6lvaxFONw Message-ID: Subject: Re: [Patch] add new parameter to pg_replication_origin_session_setup To: Heikki Linnakangas Cc: "Hayato Kuroda (Fujitsu)" , shveta malik , "pgsql-hackers@lists.postgresql.org" , "Zhijie Hou (Fujitsu)" , Doruk Yilmaz 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 On Wed, Feb 11, 2026 at 10:53=E2=80=AFAM Amit Kapila wrote: > > On Wed, Feb 4, 2026 at 12:38=E2=80=AFAM Heikki Linnakangas wrote: > > > > The new error message is not great: > > > > postgres=3D# select pg_replication_origin_session_setup('myorigin', 123= 45678); > > ERROR: could not find replication state slot for replication origin > > with OID 1 which was acquired by 12345678 > > > > Firstly, replication origin is not an OID. Secondly, it's a little > > confusing because the "replication state slot" is in fact present. > > However, it's currently inactive, i.e. not "acquired" by the given PID. > > > > I propose to change that to: > > > > postgres=3D# select pg_replication_origin_session_setup('myorigin', 123= 45678); > > ERROR: replication origin with ID 1 is not active for PID 12345678 > > > > That's more in line with this neighboring message: > > > > ERROR: replication origin with ID 1 is already active for PID 701228 > > > > +1 for the new message. > Heikki, would you like to take care of improvements proposed by you? Otherwise, I am happy to take care of them. --=20 With Regards, Amit Kapila.