PS_NITPICKS_20240718_2PC_V190003.txt

text/plain

Filename: PS_NITPICKS_20240718_2PC_V190003.txt
Type: text/plain
Part: 0
Message: Re: Slow catchup of 2PC (twophase) transactions on replica in LR
diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml
index 58db97f..e0ce83a 100644
--- a/doc/src/sgml/ref/alter_subscription.sgml
+++ b/doc/src/sgml/ref/alter_subscription.sgml
@@ -256,10 +256,15 @@ ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable> RENAME TO <
      </para>
 
      <para>
-      The <link linkend="sql-createsubscription-params-with-two-phase"><literal>two_phase</literal></link>
-      parameter can only be altered when the subscription is disabled.
-      When altering the parameter from <literal>true</literal>
-      to <literal>false</literal>, the backend process checks for any incomplete
+      The <link linkend="sql-createsubscription-params-with-failover"><literal>failover</literal></link>
+      and <link linkend="sql-createsubscription-params-with-two-phase"><literal>two_phase</literal></link>
+      parameters can only be altered when the subscription is disabled.
+     </para>
+
+     <para>
+      When altering <link linkend="sql-createsubscription-params-with-two-phase"><literal>two_phase</literal></link>
+      from <literal>true</literal> to <literal>false</literal>,
+      the backend process checks for any incomplete
       prepared transactions done by the logical replication worker (from when
       <literal>two_phase</literal> parameter was still <literal>true</literal>)
       and, if any are found, an error is reported. If this happens, you can