Subject: pgsql: Improve REPACK (CONCURRENTLY) error when wal_level < replica

From: Álvaro Herrera <[email-masked]>
Date: Thu, 28 May 2026 13:05:40 +0000

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 <[email-masked]>
Reviewed-by: Chao Li <[email-masked]>
Discussion: https://postgr.es/m/CA+fm-ROdgh0rEVuXoViBk4TVgjodrN=[email-masked]

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/43649b6a53e9b3964e921cc962f5c977bce688fd

Modified Files
--------------
src/backend/commands/repack.c | 9 +++++++++
1 file changed, 9 insertions(+)