Re: A proposal to force-drop replication slots to make disabling async/sync standbys or logical replication faster in production environments - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: A proposal to force-drop replication slots to make disabling async/sync standbys or logical replication faster in production environments
Date
Msg-id CAA4eK1+X8ZQJfvBhqcuzj+wobaz9FVY89uDU1w_DVgLiphS8Mw@mail.gmail.com
Whole thread Raw
In response to A proposal to force-drop replication slots to make disabling async/sync standbys or logical replication faster in production environments  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Responses Re: A proposal to force-drop replication slots to make disabling async/sync standbys or logical replication faster in production environments
List pgsql-hackers
On Thu, Jun 9, 2022 at 11:07 AM Bharath Rupireddy
<bharath.rupireddyforpostgres@gmail.com> wrote:
>
> Currently postgres doesn't allow dropping a replication slot that's active [1]. This can make certain operations more
time-consumingor stuck in production environments. These operations are - disable async/sync standbys and disable
logicalreplication that require the postgres running on standby or the subscriber to go down. If stopping postgres
servertakes time, the VM or container will have to be killed forcefully which can take a considerable amount of time as
thereare 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.



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Collation version tracking for macOS
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: A proposal to provide a timeout option for CREATE_REPLICATION_SLOT/pg_create_logical_replication_slot