Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Commit 21e3a8b

Browse filesBrowse files
author
Amit Kapila
committed
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
1 parent b36fbd9 commit 21e3a8b
Copy full SHA for 21e3a8b

File tree

Expand file treeCollapse file tree

1 file changed

+8
-8
lines changed
Filter options
Expand file treeCollapse file tree

1 file changed

+8
-8
lines changed

‎doc/src/sgml/ref/alter_subscription.sgml

Copy file name to clipboardExpand all lines: doc/src/sgml/ref/alter_subscription.sgml
+8-8Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -235,15 +235,15 @@ ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable> RENAME TO <
235235
<para>
236236
When altering the
237237
<link linkend="sql-createsubscription-params-with-slot-name"><literal>slot_name</literal></link>,
238-
the <literal>failover</literal> property value of the named slot may differ from the
238+
the <literal>failover</literal> and <literal>two_phase</literal> property
239+
values of the named slot may differ from the counterpart
239240
<link linkend="sql-createsubscription-params-with-failover"><literal>failover</literal></link>
240-
parameter specified in the subscription. When creating the slot,
241-
ensure the slot <literal>failover</literal> property matches the
242-
<link linkend="sql-createsubscription-params-with-failover"><literal>failover</literal></link>
243-
parameter value of the subscription. Otherwise, the slot on the
244-
publisher may behave differently from what subscription's
245-
<link linkend="sql-createsubscription-params-with-failover"><literal>failover</literal></link>
246-
option says. The slot on the publisher could either be
241+
and <link linkend="sql-createsubscription-params-with-two-phase"><literal>two_phase</literal></link>
242+
parameters specified in the subscription. When creating the slot, ensure
243+
the slot properties <literal>failover</literal> and <literal>two_phase</literal>
244+
match their counterpart parameters of the subscription.
245+
Otherwise, the slot on the publisher may behave differently from what these
246+
subscription options say: for example, the slot on the publisher could either be
247247
synced to the standbys even when the subscription's
248248
<link linkend="sql-createsubscription-params-with-failover"><literal>failover</literal></link>
249249
option is disabled or could be disabled for sync

0 commit comments

Comments
0 (0)
Morty Proxy This is a proxified and sanitized view of the page, visit original site.