I had trouble testing this at first:
postgres=# REPACK (CONCURRENTLY) users;
ERROR: 42501: permission denied to use replication slots
DETAIL: Only roles with the REPLICATION attribute may use replication slots.
CONTEXT: REPACK decoding worker
LOCATION: CheckSlotPermissions, slot.c:1697
That's surprising, since it was run as a superuser.
It turns out that repack runs as the owner of the table, and the table
*owner* needs to have REPLICATION -- regardless of who runs the command.
I imagine people have been testing with one user, that both owns the
table and invokes REPACK. Maybe this just needs to be clarified in the
documentation/error message?
--
Justin
