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

From: Shubham Khanna <khannashubham1197(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Adding a '--two-phase' option to 'pg_createsubscriber' utility.
Date: 2024-12-09 10:54:43
Message-ID: CAHv8RjLPdFP=kA5LNSmWZ=+GMXmO+LczvV6p9HJjsXxZz10KGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

I am writing to propose the addition of the two_phase option in
pg_createsubscriber. As discussed in [1], supporting this feature
during the development of pg_createsubscriber was planned for this
version.
Currently, pg_createsubscriber creates subscriptions with the
two_phase option set to false. Enabling the two_phase option after a
subscription has been created is not straightforward, as it requires
the subscription to be disabled first. This patch aims to address this
limitation by incorporating the two_phase option into
pg_createsubscriber which will help create subscription with two_phase
option and make use of the advantages of creating subscription with
two_phase option.
The attached patch has the changes for the same.

[1] - https://www.postgresql.org/message-id/CAA4eK1%2B7gRxiK3xNEH03CY3mMKxqi7BVz2k3VxxVZp8fgjHZxg%40mail.gmail.com

Thanks and regards,
Shubham Khanna.

Attachment Content-Type Size
v1-0001-Add-support-for-enabling-disabling-two-phase-comm.patch application/octet-stream 9.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2024-12-09 11:39:36 Re: Proposal for Updating CRC32C with AVX-512 Algorithm.
Previous Message Jakub Wartak 2024-12-09 10:52:16 Re: doc: Mention clock synchronization recommendation for hot_standby_feedback