diff options
| author | Amit Kapila <akapila@postgresql.org> | 2021-03-03 12:01:56 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2021-03-03 12:01:56 +0530 |
| commit | 8af3c233e423e106a5121000ecd92abf57c11704 (patch) | |
| tree | 358fd1c2f9dae15d7112c314ac63a92dcfb6b2c5 | |
| parent | e527a99055154bb7fe6ed67f0417a67cf11fa056 (diff) | |
| download | postgresql-8af3c233e423e106a5121000ecd92abf57c11704.tar.gz postgresql-8af3c233e423e106a5121000ecd92abf57c11704.zip | |
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
| -rw-r--r-- | doc/src/sgml/config.sgml | 11 | ||||
| -rw-r--r-- | doc/src/sgml/logical-replication.sgml | 11 |
2 files changed, 17 insertions, 5 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index b5718fc1366..967de73596f 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4001,6 +4001,17 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows to <literal>replica</literal> or higher to allow replication slots to be used. </para> + + <para> + On the subscriber side, specifies how many replication origins (see + <xref linkend="replication-origins"/>) can be tracked simultaneously, + effectively limiting how many logical replication subscriptions can + be created on the server. Setting it a lower value than the current + number of tracked replication origins (reflected in + <link linkend="view-pg-replication-origin-status">pg_replication_origin_status</link>, + not <link linkend="catalog-pg-replication-origin">pg_replication_origin</link>) + will prevent the server from starting. + </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/logical-replication.sgml b/doc/src/sgml/logical-replication.sgml index 9cd3f3fbb3d..e95d446dacb 100644 --- a/doc/src/sgml/logical-replication.sgml +++ b/doc/src/sgml/logical-replication.sgml @@ -603,11 +603,12 @@ <para> The subscriber also requires the <varname>max_replication_slots</varname> - to be set. In this case it should be set to at least the number of - subscriptions that will be added to the subscriber, plus some reserve for - table synchronization. <varname>max_logical_replication_workers</varname> - must be set to at least the number of subscriptions, again plus some reserve - for the table synchronization. Additionally the <varname>max_worker_processes</varname> + be set to configure how many replication origins can be tracked. In this + case it should be set to at least the number of subscriptions that will be + added to the subscriber, plus some reserve for table synchronization. + <varname>max_logical_replication_workers</varname> must be set to at least + the number of subscriptions, again plus some reserve for the table + synchronization. Additionally the <varname>max_worker_processes</varname> may need to be adjusted to accommodate for replication workers, at least (<varname>max_logical_replication_workers</varname> + <literal>1</literal>). Note that some extensions and parallel queries |