Add two-phase option in pg_createsubscriber. This patch introduces the '--enable-two-phase' option to the 'pg_createsubscriber' utility, allowing users to enable two-phase commit for all subscriptions during their creation.
Note that even without this option users can enable the two_phase option for the subscriptions created by pg_createsubscriber. However, it requires the subscription to be disabled first which could be inconvenient for users. When two-phase commit is enabled, prepared transactions are sent to the subscriber at the time of 'PREPARE TRANSACTION', and they are processed as two-phase transactions on the subscriber as well. If disabled, prepared transactions are sent only when committed and are processed immediately by the subscriber. Author: Shubham Khanna <[email protected]> Reviewed-by: vignesh C <[email protected]> Reviewed-by: Hayato Kuroda <[email protected]> Reviewed-by: Peter Smith <[email protected]> Reviewed-by: Ajin Cherian <[email protected]> Reviewed-by: Amit Kapila <[email protected]> Discussion: https://postgr.es/m/CAHv8RjLPdFP=kA5LNSmWZ=+gmxmo+lczvv6p9hjjsxxzz10...@mail.gmail.com Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/e117cfb2f6c67fe4ba46720bc6917da3dbd48c10 Modified Files -------------- doc/src/sgml/ref/pg_createsubscriber.sgml | 18 ++++- src/bin/pg_basebackup/pg_createsubscriber.c | 84 ++++++++++++++-------- src/bin/pg_basebackup/t/040_pg_createsubscriber.pl | 11 +++ 3 files changed, 83 insertions(+), 30 deletions(-)
