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

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: A proposal to force-drop replication slots to make disabling async/sync standbys or logical replication faster in production environments
Дата
Msg-id CAA4eK1+X8ZQJfvBhqcuzj+wobaz9FVY89uDU1w_DVgLiphS8Mw@mail.gmail.com
обсуждение исходный текст
Ответ на 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>)
Ответы Re: 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>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Collation version tracking for macOS
Следующее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: A proposal to provide a timeout option for CREATE_REPLICATION_SLOT/pg_create_logical_replication_slot