> Dear Vitaly, > > > I looked at the patch and realized that I can't try it easily in the near > > future > > because the solution I'm working on is based on PG16 or earlier. This patch > > is > > not easily applicable to the older releases. I have to port my solution to > > the > > master, which is not done yet. > > We also tried to port our patch for PG16, but the largest barrier was that a > replication command ALTER_SLOT is not supported. Since the slot option > two_phase > can't be modified, it is difficult to skip decoding PREPARE command even when > altering the option from true to false. > IIUC, Adding a new feature (e.g., replication command) for minor updates is > generally > prohibited > > We must consider another approach for backpatching, but we do not have > solutions > for now.
Attached patch set is a ported version for PG16, which breaks ABI. This can be used for testing purpose, but it won't be pushed to REL_16_STABLE. At least, this patchset can pass my github CI. Can you apply and check whether your issue is solved? Best Regards, Hayato Kuroda FUJITSU LIMITED https://www.fujitsu.com/
REL_16_0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIPTION.patch
Description: REL_16_0001-Allow-altering-of-two_phase-option-of-a-SUBSCRIPTION.patch
REL_16_0002-Alter-slot-option-two_phase-only-when-altering-true-.patch
Description: REL_16_0002-Alter-slot-option-two_phase-only-when-altering-true-.patch
REL_16_0003-Abort-prepared-transactions-while-altering-two_phase.patch
Description: REL_16_0003-Abort-prepared-transactions-while-altering-two_phase.patch
REL_16_0004-Add-force_alter-option.patch
Description: REL_16_0004-Add-force_alter-option.patch
