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 1wSy89-000EGP-17 for pgsql-bugs@arkaria.postgresql.org; Fri, 29 May 2026 14:24:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wSy87-002qHw-2m for pgsql-bugs@arkaria.postgresql.org; Fri, 29 May 2026 14:24:08 +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 1wSy87-002qHo-15 for pgsql-bugs@lists.postgresql.org; Fri, 29 May 2026 14:24:07 +0000 Received: from fout-b2-smtp.messagingengine.com ([202.12.124.145]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wSy7z-000000009RJ-3MK4 for pgsql-bugs@lists.postgresql.org; Fri, 29 May 2026 14:24:02 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfout.stl.internal (Postfix) with ESMTP id C5F771D00109; Fri, 29 May 2026 10:23:56 -0400 (EDT) Received: from phl-imap-07 ([10.202.2.97]) by phl-compute-04.internal (MEProxy); Fri, 29 May 2026 10:23:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm2; t=1780064636; x=1780151036; bh=RojPTsRhhaKhMo7agQg97eRX4j5lOLTkHlC4P19FzMU=; b= XugvAWROJWi715z6re1c4hbwj/06yFerYdPQkGIqhHn/JV07oOPpVO4ixuZHaFiZ GWKvRFoxQqtlFI+ZAqjoBRj6evv/pGjygyE8gqTFPKwjJeOEZQpZjRZLb3JSJiyt 4A+Smcshcjp0vW10bOH6BKqbMdWCE1ZKMyCzrRCIweiCy5LewvwkvPRbEegW+KWf RvsIRTW6A/z5VsV1RE7MN6gcTq43O8lJHARTONuK8oIDyEfDhBgqKQRQ4AGFfjjh 9bERpiXMcTFVmH3cgEjzR9IsKjwU5njh6pN7dZ2S+kRNGmpb2C6wVZNSGbJjZgeN okOGr09JNWVAxbwy/uH2MA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1780064636; x=1780151036; bh=R ojPTsRhhaKhMo7agQg97eRX4j5lOLTkHlC4P19FzMU=; b=nuIiv6eY8kEmeVAwn Pa7yjSHK5UNA2Lk4VMw4ZupLMd/fBVz33WzY3zHs8/1r4zRZhvKIAHcVgehmHEMI zyDxtHN+lQafMQY2+9AE0dpZ1H0i9rIZpYaTkc6WQ29M9pNJYdtAUU+J0Lm+4u4g 47c2EjoMuPR2/z9ZgyasitvSKOQowFYN+tpR2pBX15PjyXcKtd9vW3yEhailqNBL 63aYr8sfylNjhtd7h+ggrxx+aJz10I9/IhK5ihfJPvbKy5J7y0KqPBzTUN8cj4Zt 66vaLTSn3348N+iM6qFhVUxCYTlEAeNmHb2t/ohk0OJmg5N1qMkrlnjZBfLlVnlJ TbIzw== X-ME-Sender: X-ME-Proxy-Cause: dmFkZTEEt4qbwpa6cIy6CrCkY3DISTRm70rB4uQfxaAAXwBc2nVJ3ZTL2paH35u7VHaVXB rIsXuiuSYxLwIjgCd+dc7Q5EnnUSATQZNx2TCkPPg+tN8fLbixwUf9LOa91UsmpDSXIn6y XtDVBGjdnepPsFIr8Iy+e083zDVX1cRyPtfJ0RsZLr0fe9gvX5QYNRNSQ3FJzKTBDlxFlJ M5x88rXxM9XHdPvHBODuO+Ew9qcqJW2yEspSt9bk8OcnwN/ciFpH4mJMaNWFRXKVemeccD 8CfDf03NKs9L4sHHX4I8JF/X/h53A2WMNwLe7urhLHwaNiOggPHxfjBvy/yMu41NzjS1Jc osFGUi7L+oFbsqkYQTYciS3avB7x6qXbl8OaWcZ9IIe0mCKPGLNt1fgQiWD1F/d+1tG/n4 fVQATrFE/7vE2Cj6ptNImnZo23fL3vkwAkimkdtJNCYa6z5qfDqgaV4m9VLthb/YgVY2RQ ilBw/2aUss2ua4ySgqP9rU5pNVJlnoAE4M2A0uQyBMZ7DsMDToHIrZsXTChcCUe+UVwT7C GFHwt1o3NMdVYPcBZ+2LyR5mwo0Xj0y3zBr0fgMygZPCJkcZOV5h+sE2kC6X9VgsglMRqh Fz9NeJ0D5xLk+JhvCPZf/Sl9+pZjnoAuawoNtZ7PkJ1L6HiWBNgUcBBKeT1w X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mailuser.phl.internal (Postfix, from userid 501) id D06281EA006B; Fri, 29 May 2026 10:23:55 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface MIME-Version: 1.0 X-ThreadId: AUyocT_5HqUB Date: Fri, 29 May 2026 16:23:35 +0200 From: =?UTF-8?Q?=C3=81lvaro_Herrera?= To: n.kalinin@postgrespro.ru, pgsql-bugs@lists.postgresql.org Message-Id: In-Reply-To: <19500-38a02529a69353a5@postgresql.org> References: <19500-38a02529a69353a5@postgresql.org> Subject: Re: BUG #19500: pgrepack logical decoding plugin can crash assert builds via SQL decoding API 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 2026-05-28, PG Bug reporting form wrote: > It appears that the pgrepack output plugin is accessible through the S= QL > logical decoding API, even though the plugin code explicitly indicates= that > this interface is not supported. Reading changes from such a slot can = cause > a backend process crash in builds with asserts enabled. > Is this considered normal behavior for the pgrepack plugin, i.e. essen= tially > a =E2=80=9Cdon=E2=80=99t do that=E2=80=9D situation? Yeah, I would like to have a way to prevent this, if only for user-frien= dliness, but it's not terribly pressing since only a role with REPLICATI= ON privs can create the replication slot, which as I recall are already = pretty powerful. --=20 =C3=81lvaro Herrera