Horton

Disable logical decoding after REPACK (CONCURRENTLY)

Álvaro Herrera <alvherre@kurilemu.de>

View on postgr.es
Commit: 2af1dc89282bea681201cf66e2bb32537294e623
Author: Álvaro Herrera <alvherre@kurilemu.de>
Date: 2026-05-27T18:11:29Z
Releases: 19 (unreleased) 
Disable logical decoding after REPACK (CONCURRENTLY)

REPACK (CONCURRENTLY) uses a temporary logical replication slot, which
is dropped once done, but it wasn't calling RequestDisableLogicalDecoding(),
leaving effective_wal_level stuck at 'logical'.

Fix by adding a Boolean flag to ReplicationSlotDropAcquired() to have it
request to disable logical decoding, and passing it as true on REPACK.
Other callers of that function preserve their existing behavior.

Author: Imran Zaheer <imran.zhir@gmail.com>
Reviewed-by: shveta malik <shveta.malik@gmail.com>
Discussion: https://postgr.es/m/CA+UBfaktds57dw2M8BEv_kS-=ixph3w+3MxKixtaDQMi_k7Ybg@mail.gmail.com

Files

PathChange+/−
src/backend/commands/repack_worker.c modified +1 −1
src/backend/replication/logical/launcher.c modified +2 −1
src/backend/replication/logical/slotsync.c modified +8 −2
src/backend/replication/slot.c modified +21 −27
src/include/replication/slot.h modified +1 −1
src/test/recovery/t/051_effective_wal_level.pl modified +14 −0

Discussion