aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorAmit Kapila <akapila@postgresql.org>2024-03-11 09:33:04 +0530
committerAmit Kapila <akapila@postgresql.org>2024-03-11 09:33:04 +0530
commit21e3a8bc3544a1cfcff85933bc9c0664af32a8b8 (patch)
tree7e32f316d5ee13ba3781a876bdf81e2adddf03dc /doc/src
parentb36fbd9f8da140f5b0ef9f7daa6b3cb4cae8a69b (diff)
downloadpostgresql-21e3a8bc3544a1cfcff85933bc9c0664af32a8b8.tar.gz
postgresql-21e3a8bc3544a1cfcff85933bc9c0664af32a8b8.zip
Doc: Warn about two_phase when altering a subscription's slot name.
We expect the 'two_phase' and 'failover' properties to match between the slot on the publisher and a subscription option on the subscriber. Otherwise, the slot on the publisher may behave differently from what the subscription's failover option says. Author: Bertrand Drouvot Reviewed-by: Peter Smith, Tristen Raab, Amit Kapila Discussion: https://postgr.es/m/ZbkYrLPhH+RxpZlW@ip-10-97-1-34.eu-west-3.compute.internal
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/alter_subscription.sgml16
1 files changed, 8 insertions, 8 deletions
diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml
index e9e6d9d74ad..413ce68ce2c 100644
--- a/doc/src/sgml/ref/alter_subscription.sgml
+++ b/doc/src/sgml/ref/alter_subscription.sgml
@@ -235,15 +235,15 @@ ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable> RENAME TO <
<para>
When altering the
<link linkend="sql-createsubscription-params-with-slot-name"><literal>slot_name</literal></link>,
- the <literal>failover</literal> property value of the named slot may differ from the
+ the <literal>failover</literal> and <literal>two_phase</literal> property
+ values of the named slot may differ from the counterpart
<link linkend="sql-createsubscription-params-with-failover"><literal>failover</literal></link>
- parameter specified in the subscription. When creating the slot,
- ensure the slot <literal>failover</literal> property matches the
- <link linkend="sql-createsubscription-params-with-failover"><literal>failover</literal></link>
- parameter value of the subscription. Otherwise, the slot on the
- publisher may behave differently from what subscription's
- <link linkend="sql-createsubscription-params-with-failover"><literal>failover</literal></link>
- option says. The slot on the publisher could either be
+ and <link linkend="sql-createsubscription-params-with-two-phase"><literal>two_phase</literal></link>
+ parameters specified in the subscription. When creating the slot, ensure
+ the slot properties <literal>failover</literal> and <literal>two_phase</literal>
+ match their counterpart parameters of the subscription.
+ Otherwise, the slot on the publisher may behave differently from what these
+ subscription options say: for example, the slot on the publisher could either be
synced to the standbys even when the subscription's
<link linkend="sql-createsubscription-params-with-failover"><literal>failover</literal></link>
option is disabled or could be disabled for sync