NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit21e3a8b

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 theslot on the publisher and a subscription option on the subscriber.Otherwise, the slot on the publisher may behave differently from what thesubscription's failover option says.Author: Bertrand DrouvotReviewed-by: Peter Smith, Tristen Raab, Amit KapilaDiscussion:https://postgr.es/m/ZbkYrLPhH+RxpZlW@ip-10-97-1-34.eu-west-3.compute.internal

1 parentb36fbd9 commit21e3a8bCopy full SHA for 21e3a8b

File tree

1 file changed

-8

lines changed

doc/src/sgml/ref
- alter_subscription.sgml

1 file changed

-8

lines changed

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

Lines changed: 8 additions & 8 deletions

Original file line number	Diff line number	Diff line change
`@@ -235,15 +235,15 @@ ALTER SUBSCRIPTION <replaceable class="parameter">name</replaceable> RENAME TO <`
`235`	`235`	`<para>`
`236`	`236`	`When altering the`
`237`	`237`	`<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`
`239`	`240`	`<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`
`247`	`247`	`synced to the standbys even when the subscription's`
`248`	`248`	`<link linkend="sql-createsubscription-params-with-failover"><literal>failover</literal></link>`
`249`	`249`	`option is disabled or could be disabled for sync`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit21e3a8b

File tree

1 file changed

1 file changed

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

0 commit comments