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

Ioseph Kim <pgsql-kr@postgresql.kr>

From: Ioseph Kim <pgsql-kr@postgresql.kr>
To: pgsql-hackers@lists.postgresql.org
Date: 2025-12-11T06:39:16Z
Lists: pgsql-hackers

Attachments

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