Make pg_createsubscriber warn if publisher has two-phase commit enabled.
authorTom Lane <tgl@sss.pgh.pa.us>
Sun, 30 Jun 2024 18:24:14 +0000 (14:24 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sun, 30 Jun 2024 18:24:14 +0000 (14:24 -0400)
commit917754557cc0002bb042341720a7ce18fe5b0a09
treeadd6e56289d799bf85cea6059a589a9fa64ef000
parentb3f5ccebd79d9c7b73f4e04611cdf31fdf87420b
Make pg_createsubscriber warn if publisher has two-phase commit enabled.

pg_createsubscriber currently always sets up logical replication
with two-phase commit disabled.  Improving that is not going to
happen for v17.  In the meantime, document the deficiency, and
adjust pg_createsubscriber so that it will emit a warning if
the source installation has max_prepared_transactions > 0.

Hayato Kuroda (some mods by Amit Kapila and me), per complaint from
Noah Misch

Discussion: https://postgr.es/m/20240623062157.97.nmisch@google.com
doc/src/sgml/ref/pg_createsubscriber.sgml
src/bin/pg_basebackup/pg_createsubscriber.c