Dear Shveta,
> When I said that option 2 aligns with ALTER-SUB documented behaviour,
> I meant the doc described in [1] stating "When altering the slot_name,
> the failover and two_phase property values of the named slot may
> differ from the counterpart failover and two_phase parameters
> specified in the subscription...."
>
> [1]:
> https://www.postgresql.org/docs/devel/sql-altersubscription.html#SQL-ALTER
> SUBSCRIPTION-PARAMS-SET
I see, thanks for the clarification. Agreed that the description is not conflict with
option 2.
Best Regards,
Hayato Kuroda
FUJITSU LIMITED
https://www.fujitsu.com/