Re: Propose: Adding a '--enable-failover' option to 'pg_createsubscriber' ver.3

From: Ioseph Kim <pgsql-kr(at)postgresql(dot)kr>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Propose: Adding a '--enable-failover' option to 'pg_createsubscriber' ver.3
Date: 2025-12-11 06:39:16
Message-ID: 20251211063916.GA16026@postgresql.kr
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

TAP test codes are added in the patch
and manual has become more user-friendly.

Please review the patch and let me know if you see a better solution. I’ll be glad to update it accordingly.

ioseph

On Wed, Dec 10, 2025 at 06:03:48PM +0900, Ioseph Kim wrote:
> Hi
>
> A failover option has been added to the CREATE SUBSCRITION command, but this functionality isn't easily accessible using the pg_createsubscriber tool.
>
> Subscriptions created using pg_createsubscriber must be configured for failover via an alter operation.
>
> To address this issue, we've added a simple --enable-failover option to the pg_createsubscriber tool.
>
> This patch is simple. It doesn't handle exceptions or provide any TAP test code.
>
> Please review this and we hope the development team will refine it further.
>
> ioseph

Attachment Content-Type Size
0001-Adding-a-enable-failover-option-to-pg_createsubscrib-v3.patch text/x-diff 7.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhijie Hou (Fujitsu) 2025-12-11 07:09:21 RE: Newly created replication slot may be invalidated by checkpoint
Previous Message Alexander Pyhalov 2025-12-11 06:38:13 Re: postgres_fdw prefers fast plans