Type: | integer |
Default: | 10 |
Min: | 0 |
Max: | 262143 |
Context: | postmaster |
Restart: | true |
Since: | 9.4 |
Specifies the maximum number of replication slots (see streaming-replication-slots) that the server can support. The default is 10. This parameter can only be set at server start. Setting it to a lower value than the number of currently existing replication slots will prevent the server from starting. Also, wal_level must be set to replica
or higher to allow replication slots to be used.
Recommendations
Set to twice as many replicas as you ever expect to have.
On StackOverflow
- Multiple replication slot for debezium connector
- Postgres 10 Upgrade Stuck Queries
- Postgresql Replication slot error postgresql
- Getting Exception : "replication slot "XXX" is active for PID XXX`" on deploying service on kubernetes with RollingUpdate deployment strategy
- postgresql 9.4 streaming replication
On pgsql-hackers
- Re: Read access for pg_monitor to pg_replication_origin_status view
- Re: [HACKERS] Restricting maximum keep segments by repslots
- Re: Resetting spilled txn statistics in pg_stat_replication
- Avoid unnecessary ReplicationSlotControl lwlock acquistion
- Re: Avoid unnecessary ReplicationSlotControl lwlock acquistion