Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.

On Wed, Jun 18, 2025 at 10:32 AM David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>>
>> The list can be longer than one or two. We may need to provide similar
>> options for other objects, such as replication slots (synced failover
>> replication slots on the physical standby), user-defined functions,
>> triggers, views, materialized views, operators, policies, etc. And
>> then, we would also need 'all' kind of additional option to allow
>> cleaning all such objects. The newly formed subscriber may need a few
>> of the objects that got replicated on the prior physical standby to
>> operate, but not all.
>>
>
> --verb-objecttype=pattern ? (*.* could stand in for all)
>

For some of the pending cases, like synced replication slots, we will
always need to remove all objects, but there could be a few objects
for which we need a pattern, as you are suggesting. So, we can think
of adding such special switches only for those objects, if required,
similar to what pg_dump has for schema or tables.

--
With Regards,
Amit Kapila.