Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility.

vignesh C <vignesh21@gmail.com>

From: vignesh C <vignesh21@gmail.com>
To: Shubham Khanna <khannashubham1197@gmail.com>
Cc: Peter Smith <smithpb2250@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-12-11T08:38:23Z
Lists: pgsql-hackers

Attachments

On Wed, 11 Dec 2024 at 11:21, Shubham Khanna
<khannashubham1197@gmail.com> wrote:
>
> On Wed, Dec 11, 2024 at 4:21 AM Peter Smith <smithpb2250@gmail.com> wrote:
>
> I have fixed the given comments. The attached patch contains the
> suggested changes.

Since all the subscriptions are created based on the two_phase option
provided, there is no need to store this for each database:
@@ -53,6 +54,7 @@ struct LogicalRepInfo
        char       *pubname;            /* publication name */
        char       *subname;            /* subscription name */
        char       *replslotname;       /* replication slot name */
+       bool            two_phase;              /* two-phase enabled
for the subscription */

                dbinfo[i].dbname = cell->val;
+               dbinfo[i].two_phase = opt->two_phase;
                if (num_pubs > 0)

How about we handle something like in the attached changes.

Regards,
Vignesh

Commits

  1. Add two-phase option in pg_createsubscriber.