MIME-Version: 1.0
References: 
 <CAHv8RjL4OvoYafofTb_U_JD5HuyoNowBoGpMfnEbhDSENA74Kg@mail.gmail.com>
 <OSCPR01MB1496664FDC38DA40A441F449FF5EE2@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <CAHv8RjJw2xDyWgagdAL7RBUEEEZtKcVJO_gNjQQHkUj8QrmwuQ@mail.gmail.com>
 <CANhcyEUkQybOe=J5KypWQ80deULBLjjsdyP+DF57+BwSni57Vw@mail.gmail.com>
 <CAHv8Rj+1v6257anqijp90f3cdZvSOhkm_ZRQRVU1C_0OYq056g@mail.gmail.com>
 <OSCPR01MB1496679AD9C3C47DB30542ECBF5F12@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <CAHv8RjJGjA_fwJ_TNrHbyTz7ATA1MXfNxPhoBvJfKRfk1Qf-ng@mail.gmail.com>
 <CANhcyEXfn-TGW2L991vXAaGH-UVBCAZuDUSRFTyVTQPbDgamdA@mail.gmail.com>
 <CAHv8RjKGywu+3cAv9MPgxi1_TUXBT8yzUsW+f=g5UsgeJ8Uk6g@mail.gmail.com>
 <CANhcyEUo7F954LULk859xs6FtwQ5USH6C2tiBbGwpihU2yHmAQ@mail.gmail.com>
 <CAHv8Rj+=5k_i=HJBE=615CckH6qi4B1n9jzhseKSH65MMkovNQ@mail.gmail.com>
 <CANhcyEWSsx_kSY4o89Yv6UfHkTVB727OiExcB8944ez0EixJGw@mail.gmail.com>
 <CAHv8RjJhwr7BqwFhMpcjjgYk9F-=MCx10LCiff9=7=vD-cj4GA@mail.gmail.com>
 <CAHut+Pt9AidicguCX8b0etzP8_hy0RmAfgLR2wKC3cxeuz5E=w@mail.gmail.com>
 <CAHv8RjLgLCbg-e0_5Ly_-8AojraV1R1g4BuaL-an7+iTLMycLg@mail.gmail.com>
 <CAHut+PvwoLheTMkUgu_syf6cUR+-E62ChOZw9Aohq0i5soeaBw@mail.gmail.com>
 <CAHv8Rj+zmkwunNubo+_Gp26S_qXbD=p+rMfEnPnjiEE1A6GTXQ@mail.gmail.com>
 <OSCPR01MB14966189AEFD119DD04FE6B42F5C32@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <CAHv8RjK__mzyo0unKp2-ObxJh_Y43p5tG6p5e1HdNHDV+z=5sw@mail.gmail.com>
 <OSCPR01MB14966C184318EA5F21823F9DFF5C92@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <CAHv8RjL4mWy9LUu1Ufat4ojqbf5bZEFkPcxN1B0ASC5-w=qvaA@mail.gmail.com>
 <CABdArM7A7vp0KwiQAm=JDUbg=jwBfPpw29veTO+pPYDTX8j-jw@mail.gmail.com>
 <CAHv8RjKeLgD3DSzKMOucb_UpiFWx5pOwQkPL+bXVm6uyFGbNYA@mail.gmail.com>
 <CAHut+PtRZbuF_vAva6azC+6WVPyaoqT1fCeLNP0r5gwPEsfcwg@mail.gmail.com>
 <CAHv8RjKmf5bAcgTmGToWSn_Fx+O2y8qCiLScBXvBTD0D5gX2sw@mail.gmail.com>
 <CABdArM7wLxPzYBMBk2PbrzSyJ1ZisXhDtMdVBnKBVMqNpBzUBA@mail.gmail.com>
 <CAHv8RjLYEr8RSFxceoosudLdN46vOJY04k9Z-4ZknTGK8u_tiA@mail.gmail.com>
 <CABdArM6_Dy5R9+mUEXS7BJfwjuu4vpy2fmMP7EyrHU=fS2srkA@mail.gmail.com>
 <CAHv8RjJVmj9qOCYwG+CRxHEfSP-WD6E5sj=h5ZeYd=H5myOAOg@mail.gmail.com>
 <CAHut+Pt_4f-=h71qmfWhiFcqTcfqWQr1POnFdesZK1-fVOCaUA@mail.gmail.com>
 <CAKFQuwaed2fr2k81kWw-UB6wp2SsitXj=9FFvvzcOT_qQtg43Q@mail.gmail.com>
 <CAHut+Pt0-KuSKqTuYaRYNrd634gR4ddnrpPsCnaSmEnHVZEucQ@mail.gmail.com>
 <CAKFQuwb-4C3L37JbnN7R-AtVE71c+Xy1tTbA=QaTrDzEJzTEEg@mail.gmail.com>
 <CAA4eK1LLRwHtrRQQRiV2N-E-W0MniTno_Q_pzze_FFesS+BaaA@mail.gmail.com>
 <CAKFQuwbH+xJmsvTTgKfnVu6B1SxNrpAge1pBjMCvsXgGDGbNhg@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwbH+xJmsvTTgKfnVu6B1SxNrpAge1pBjMCvsXgGDGbNhg@mail.gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
Date: Wed, 12 Mar 2025 10:04:49 +0530
Message-ID: 
 <CAA4eK1Lxkq7KhCh+S9H05uWJyBBSZBmb9jHYkuO2P+ZmPZvxTw@mail.gmail.com>
Subject: Re: Adding a '--clean-publisher-objects' option to
 'pg_createsubscriber' utility.
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Peter Smith <smithpb2250@gmail.com>,
 Shubham Khanna <khannashubham1197@gmail.com>,
	Nisha Moond <nisha.moond412@gmail.com>,
	"Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>,
 Shlok Kyal <shlok.kyal.oss@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAA4eK1Lxkq7KhCh%2BS9H05uWJyBBSZBmb9jHYkuO2P%2BZmPZvxTw%40mail.gmail.com>
Precedence: bulk

On Wed, Mar 12, 2025 at 9:43=E2=80=AFAM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> I=E2=80=99m honestly question how much value this provides - no improveme=
nt here seems like a viable choice.  Let them issue the drop commands they =
desire manually.  This doesn=E2=80=99t feel like something one should/would=
 automate.
>

There is a good chance of mistakenly dropping the required objects
manually after the subscriber is converted. One can mistakenly drop
the required publication unless they have some strict rule to do it
immediately after the tool has converted standby to subscriber.
Providing the commands via file is a way, but as a user, I would
prefer to get the things done automatically via a tool instead of me
doing it afterward unless there is no other way..

--=20
With Regards,
Amit Kapila.