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.
On the subscriber side, specifies how many replication origins (see replication-origins) can be tracked simultaneously, effectively limiting how many logical replication subscriptions can be created on the server. Setting it to a lower value than the current number of tracked replication origins (reflected in pg_replication_origin_status, not pg_replication_origin) will prevent the server from starting.
Recommendations
On StackOverflow
On pgsql-hackers
- Re: Force streaming every change in logical decoding
- Re: GUC values - recommended way to declare the C variables?
- Re: Perform streaming logical transactions by background workers and parallel apply
- Re: [PATCH] Reuse Workers and Replication Slots during Logical Replication
- GUC values - recommended way to declare the C variables?