diff options
author | Amit Kapila <akapila@postgresql.org> | 2025-02-26 11:12:50 +0530 |
---|---|---|
committer | Amit Kapila <akapila@postgresql.org> | 2025-02-26 11:12:50 +0530 |
commit | e117cfb2f6c67fe4ba46720bc6917da3dbd48c10 (patch) | |
tree | ebe5e19afdf9b40a2f0ebe68b980e261476384aa /src/backend/utils/adt/pgstatfuncs.c | |
parent | adc6032fa8824e7653252b02abc6a59d8b9d01a6 (diff) | |
download | postgresql-e117cfb2f6c67fe4ba46720bc6917da3dbd48c10.tar.gz postgresql-e117cfb2f6c67fe4ba46720bc6917da3dbd48c10.zip |
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 <khannashubham1197@gmail.com>
Reviewed-by: vignesh C <vignesh21@gmail.com>
Reviewed-by: Hayato Kuroda <kuroda.hayato@fujitsu.com>
Reviewed-by: Peter Smith <smithpb2250@gmail.com>
Reviewed-by: Ajin Cherian <itsajin@gmail.com>
Reviewed-by: Amit Kapila <amit.kapila16@gmail.com>
Discussion: https://postgr.es/m/CAHv8RjLPdFP=kA5LNSmWZ=+GMXmO+LczvV6p9HJjsXxZz10KGA@mail.gmail.com
Diffstat (limited to 'src/backend/utils/adt/pgstatfuncs.c')
0 files changed, 0 insertions, 0 deletions