Configuration parameter

max_replication_slots — PostgreSQL Configuration Parameter

Category Replication Default 10 Unit boolean / enum / numeric Change scope Restart required

Max replication slots (physical + logical).

At a glance

Property Value
Parameter max_replication_slots
Category Replication
Default 10
Value type boolean / enum / numeric
Change scope Restart required

What it does

Maximum number of replication slots the server can define. Slots guarantee the primary keeps WAL until a consumer has it.

How to apply a change

Requires a full server restart (postmaster context). Set it in postgresql.conf and restart PostgreSQL.

Inspect the current value and source with SHOW max_replication_slots; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'max_replication_slots';.

Tuning guidance

Provision one per standby and per logical subscription. Beware: an inactive slot pins WAL forever and can fill pg_wal — monitor pg_replication_slots and drop abandoned slots.

Reference

PostgreSQL documentation — Replication configuration.

Was this helpful?

← All configuration parameters