I'll work on pg_create_logical_replication_slot() API. pg_replication_slots view must also be adjusted to display the new flag allow_overwrite.
Regards Fabrice On Thu, Aug 14, 2025 at 8:07 AM shveta malik <shveta.ma...@gmail.com> wrote: > On Wed, Aug 13, 2025 at 9:29 PM Fabrice Chapuis <fabrice636...@gmail.com> > wrote: > > > > Thanks for sharing this. In fact, I agree, introducing an > allow_overwrite slot property makes seems cleaner than a GUC for this > specific use case. > > > > a) At first, an extension of pg_create_logical_replication_slot() could > be proposed > > b) pg_alter_logical_replication_slot(): that could be is a neat > approach, a generic API for modifying other slot properties seems like a > forward-looking design choice. However I don't know if slot properties > could be modified easily because when slot is active, a process is holding > them in memory. > > Right, it can not be.This API can be used when the slot is not > acquired by any other process. We may have use-cases for that as well > similar to one we have for this switchover case. > > thanks > Shveta >
