public inbox for [email protected]
help / color / mirror / Atom feedFrom: Amit Kapila <[email protected]>
To: David G. Johnston <[email protected]>
Cc: Peter Smith <[email protected]>
Cc: Shubham Khanna <[email protected]>
Cc: Nisha Moond <[email protected]>
Cc: Hayato Kuroda (Fujitsu) <[email protected]>
Cc: Shlok Kyal <[email protected]>
Cc: PostgreSQL Hackers <[email protected]>
Subject: Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.
Date: Wed, 12 Mar 2025 10:04:49 +0530
Message-ID: <CAA4eK1Lxkq7KhCh+S9H05uWJyBBSZBmb9jHYkuO2P+ZmPZvxTw@mail.gmail.com> (raw)
In-Reply-To: <CAKFQuwbH+xJmsvTTgKfnVu6B1SxNrpAge1pBjMCvsXgGDGbNhg@mail.gmail.com>
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>
On Wed, Mar 12, 2025 at 9:43 AM David G. Johnston
<[email protected]> wrote:
>
> I’m honestly question how much value this provides - no improvement here seems like a viable choice. Let them issue the drop commands they desire manually. This doesn’t 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..
--
With Regards,
Amit Kapila.
view thread (86+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.
In-Reply-To: <CAA4eK1Lxkq7KhCh+S9H05uWJyBBSZBmb9jHYkuO2P+ZmPZvxTw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox