diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 18 | ||||
| -rw-r--r-- | doc/src/sgml/logicaldecoding.sgml | 5 |
2 files changed, 22 insertions, 1 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index ffd711b7f21..ff184003feb 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -4943,6 +4943,24 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class=" </listitem> </varlistentry> + <varlistentry id="guc-sync-replication-slots" xreflabel="sync_replication_slots"> + <term><varname>sync_replication_slots</varname> (<type>boolean</type>) + <indexterm> + <primary><varname>sync_replication_slots</varname> configuration parameter</primary> + </indexterm> + </term> + <listitem> + <para> + It enables a physical standby to synchronize logical failover slots + from the primary server so that logical subscribers can resume + replication from the new primary server after failover. + </para> + <para> + It is disabled by default. This parameter can only be set in the + <filename>postgresql.conf</filename> file or on the server command line. + </para> + </listitem> + </varlistentry> </variablelist> </sect2> diff --git a/doc/src/sgml/logicaldecoding.sgml b/doc/src/sgml/logicaldecoding.sgml index eceaaaa2735..930c0fa8a6d 100644 --- a/doc/src/sgml/logicaldecoding.sgml +++ b/doc/src/sgml/logicaldecoding.sgml @@ -373,7 +373,10 @@ postgres=# select * from pg_logical_slot_get_changes('regression_slot', NULL, NU <command>CREATE SUBSCRIPTION</command> during slot creation, and then calling <link linkend="pg-sync-replication-slots"> <function>pg_sync_replication_slots</function></link> - on the standby. For the synchronization to work, it is mandatory to + on the standby. By setting <link linkend="guc-sync-replication-slots"> + <varname>sync_replication_slots</varname></link> + on the standby, the failover slots can be synchronized periodically in + the slotsync worker. For the synchronization to work, it is mandatory to have a physical replication slot between the primary and the standby aka <link linkend="guc-primary-slot-name"><varname>primary_slot_name</varname></link> should be configured on the standby, and |