diff options
| author | Amit Kapila <akapila@postgresql.org> | 2024-03-11 09:33:04 +0530 |
|---|---|---|
| committer | Amit Kapila <akapila@postgresql.org> | 2024-03-11 09:33:04 +0530 |
| commit | 21e3a8bc3544a1cfcff85933bc9c0664af32a8b8 (patch) | |
| tree | 7e32f316d5ee13ba3781a876bdf81e2adddf03dc /doc/src | |
| parent | b36fbd9f8da140f5b0ef9f7daa6b3cb4cae8a69b (diff) | |
| download | postgresql-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.sgml | 16 |
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 |