Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit 21d5a06

Browse filesBrowse files
author
Amit Kapila
committed
Clarify the usage of max_replication_slots on the subscriber side.
It was not clear in the docs that the max_replication_slots is also used to track replication origins on the subscriber side. Author: Paul Martinez Reviewed-by: Amit Kapila Backpatch-through: 10 where logical replication was introduced Discussion: https://postgr.es/m/CACqFVBZgwCN_pHnW6dMNCrOS7tiHCw6Retf_=U2Vvj3aUSeATw@mail.gmail.com
1 parent b52fd1e commit 21d5a06
Copy full SHA for 21d5a06

File tree

Expand file treeCollapse file tree

2 files changed

+16
-5
lines changed
Filter options
Expand file treeCollapse file tree

2 files changed

+16
-5
lines changed

‎doc/src/sgml/config.sgml

Copy file name to clipboardExpand all lines: doc/src/sgml/config.sgml
+11Lines changed: 11 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3891,6 +3891,17 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
38913891
to <literal>replica</literal> or higher to allow replication slots to
38923892
be used.
38933893
</para>
3894+
3895+
<para>
3896+
On the subscriber side, specifies how many replication origins (see
3897+
<xref linkend="replication-origins"/>) can be tracked simultaneously,
3898+
effectively limiting how many logical replication subscriptions can
3899+
be created on the server. Setting it a lower value than the current
3900+
number of tracked replication origins (reflected in
3901+
<link linkend="view-pg-replication-origin-status">pg_replication_origin_status</link>,
3902+
not <link linkend="catalog-pg-replication-origin">pg_replication_origin</link>)
3903+
will prevent the server from starting.
3904+
</para>
38943905
</listitem>
38953906
</varlistentry>
38963907

‎doc/src/sgml/logical-replication.sgml

Copy file name to clipboardExpand all lines: doc/src/sgml/logical-replication.sgml
+5-5Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -588,11 +588,11 @@
588588

589589
<para>
590590
The subscriber also requires the <varname>max_replication_slots</varname>
591-
to be set. In this case it should be set to at least the number of
592-
subscriptions that will be added to the subscriber.
593-
<varname>max_logical_replication_workers</varname> must be set to at
594-
least the number of subscriptions, again plus some reserve for the table
595-
synchronization. Additionally the <varname>max_worker_processes</varname>
591+
be set to configure how many replication origins can be tracked. In this
592+
case it should be set to at least the number of subscriptions that will be
593+
added to the subscriber. <varname>max_logical_replication_workers</varname>
594+
must be set to at least the number of subscriptions, again plus some reserve
595+
for the table synchronization. Additionally the <varname>max_worker_processes</varname>
596596
may need to be adjusted to accommodate for replication workers, at least
597597
(<varname>max_logical_replication_workers</varname>
598598
+ <literal>1</literal>). Note that some extensions and parallel queries

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.