Re: Enhance pg_createsubscriber to create required standby.

On Wed, Jun 18, 2025 at 10:43 AM David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Tue, Jun 17, 2025 at 9:22 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
>>
>>
>> As shown in Vignesh's email [1] (point 4), there could be multiple
>> additional parameters required for the first option suggested by you,
>> which will make it longer. Additionally, there are some other benefits
>> of having the second option (pg_createsubscriber --create-standby),
>> like better cleanup of contents during failures and better progress
>> reporting. Are you still against adding such an option?
>>
>> [1]: https://www.postgresql.org/message-id/CALDaNm1biZBMOzFMfHYzqrAeosJSD5YRG%3D82-pp6%2BJhALsfe6w%40mail.gmail.com
>>
>
> None of those benefits convince me that "let's write a shell script in C and put it under an annual feature release policy" is the way to go here.
>

I don't think it is equivalent to writing a simple script as you are
imagining, for example the future enhancements in this tool could make
such scripts require constant updates. Also, not sure providing Ctrl+C
or progress reporting would be any easier with scripting.

I feel this is a basic requirement to create a subscriber-node from
scratch and for that if we refer users for external scripts, it would
be inconvenient for users.

--
With Regards,
Amit Kapila.