Re: BUG #19500: pgrepack logical decoding plugin can crash assert builds via SQL decoding API - Mailing list pgsql-bugs

From Álvaro Herrera
Subject Re: BUG #19500: pgrepack logical decoding plugin can crash assert builds via SQL decoding API
Date
Msg-id add10bd7-d351-4630-858b-b9b77144f0a9@app.fastmail.com
Whole thread
In response to BUG #19500: pgrepack logical decoding plugin can crash assert builds via SQL decoding API  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #19500: pgrepack logical decoding plugin can crash assert builds via SQL decoding API
List pgsql-bugs
Hi,

On 2026-05-28, PG Bug reporting form wrote:

> It appears that the pgrepack output plugin is accessible through the SQL
> 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. essentially
> a “don’t do that” situation?

Yeah, I would like to have a way to prevent this, if only for user-friendliness, but it's not terribly pressing since
onlya role with REPLICATION privs can create the replication slot, which as I recall are already pretty powerful. 

--
Álvaro Herrera



pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #19494: Error on transaction commit inside pipeline triggers psql's Assert
Next
From: PG Bug reporting form
Date:
Subject: BUG #19501: btree_gist: use float4/float8 comparison functions to handle NaN correctly