Re: Propose: Adding a '--enable-failover' option to 'pg_createsubscriber' ver.3 - Mailing list pgsql-hackers

From Ioseph Kim
Subject Re: Propose: Adding a '--enable-failover' option to 'pg_createsubscriber' ver.3
Date
Msg-id 20251211063916.GA16026@postgresql.kr
Whole thread Raw
In response to Propose: Adding a '--enable-failover' option to 'pg_createsubscriber'  (Ioseph Kim <pgsql-kr@postgresql.kr>)
Responses Re:Re: Propose: Adding a '--enable-failover' option to 'pg_createsubscriber' ver.3
List 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
usingthe 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

pgsql-hackers by date:

Previous
From: Alexander Pyhalov
Date:
Subject: Re: postgres_fdw prefers fast plans
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: Newly created replication slot may be invalidated by checkpoint