Doc: Warn about two_phase when altering a subscription's slot name.

Amit Kapila · Amit Kapila · commit 21e3a8bc3544 · 2024-03-11T09:33:04.000+05:30
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
diff --git 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
