On Thu, Jun 9, 2022 at 11:07 AM Bharath Rupireddy
<bharath(dot)rupireddyforpostgres(at)gmail(dot)com> wrote:
>
> Currently postgres doesn't allow dropping a replication slot that's active [1]. This can make certain operations more time-consuming or stuck in production environments. These operations are - disable async/sync standbys and disable logical replication that require the postgres running on standby or the subscriber to go down. If stopping postgres server takes time, the VM or container will have to be killed forcefully which can take a considerable amount of time as there are many layers in between.
>
Why do you want to drop the slot when the server is going down? Is it
some temporary replication slot, otherwise, how will you resume
replication after restarting the server?
--
With Regards,
Amit Kapila.