Improve REPACK (CONCURRENTLY) error when wal_level < replica

Álvaro Herrera <alvherre@kurilemu.de>

Commit: 43649b6a53e9b3964e921cc962f5c977bce688fd
Author: Álvaro Herrera <alvherre@kurilemu.de>
Date: 2026-05-28T13:04:36Z
Improve REPACK (CONCURRENTLY) error when wal_level < replica

The error emitted when REPACK (CONCURRENTLY) is run with too low a
wal_level is thrown by CheckSlotRequirements(), which is a bit
mysterious when the user doesn't know what's up.  Add an upfront check
in check_concurrent_repack_requirements() for a more explicit, REPACK-
centered report, which is easier to understand -- this also saves
starting the worker just to have it die immediately.

Author: Baji Shaik <baji.pgdev@gmail.com>
Reviewed-by: Chao Li <li.evan.chao@gmail.com>
Discussion: https://postgr.es/m/CA+fm-ROdgh0rEVuXoViBk4TVgjodrN=MTR_RYuOuKLZ9voX4YA@mail.gmail.com

Files

PathChange+/−
src/backend/commands/repack.c modified +9 −0

Discussion