Horton

Fix the handling of the failover option in subscription commands.

Amit Kapila <akapila@postgresql.org>

View on postgr.es
Commit: b29cbd3da4e37db17026b9fe58fb46fe83f467bf
Author: Amit Kapila <akapila@postgresql.org>
Date: 2024-04-23T06:52:30Z
Releases: 17.0 
Fix the handling of the failover option in subscription commands.

Do not allow ALTER SUBSCRIPTION ... SET (failover = on|off) in a
transaction block as the changed failover option of the slot can't be
rolled back. For the same reason, we refrain from altering the replication
slot's failover property if the subscription is created with a valid
slot_name and create_slot=false.

Reprted-by: Kuroda Hayato
Author: Hou Zhijie
Reviewed-by: Shveta Malik, Bertrand Drouvot, Kuroda Hayato
Discussion: https://postgr.es/m/OS0PR01MB57165542B09DFA4943830BF294082@OS0PR01MB5716.jpnprd01.prod.outlook.com

Files

PathChange+/−
doc/src/sgml/ref/alter_subscription.sgml modified +4 −3
doc/src/sgml/ref/create_subscription.sgml modified +16 −2
doc/src/sgml/ref/pg_dump.sgml modified +1 −5
src/backend/commands/subscriptioncmds.c modified +6 −22
src/bin/pg_dump/pg_dump.c modified +12 −15
src/test/recovery/t/040_standby_failover_slots_sync.pl modified +3 −17
src/test/regress/expected/subscription.out modified +5 −2
src/test/regress/sql/subscription.sql modified +5 −1

Documentation touched

Discussion