Instrumenting stale replication slots

Поиск
Список
Период
Сортировка
От Joseph Hammerman
Тема Instrumenting stale replication slots
Дата
Msg-id CAHs7QM888FG=Ndkwa1rZjcOC=AWuWmiFroyUkEuP7Un9O7frwg@mail.gmail.com
обсуждение исходный текст
Список pgsql-admin
Hi admins,

We are looking to regularly create `inactive` logical replication slots under test conditions so that we can demonstrate that applying Debezium's heartbeat feature reliably remediates the condition and prevents stale WALs from accumulating.

Published material from RedHat states that by advancing the LSN on the primary with updates that are not captured by the Replica Set configured to use the slot in question will induce the state, but we have not yet been able to show this, even with thousands of updates that are filtered from the Logical Slot.

Does anyone have any advice around mechanically inducing the `inactive` Logical Replica slot state?

Thanks,
Joe

В списке pgsql-admin по дате отправления:

Предыдущее
От: Sushil Shirodkar
Дата:
Сообщение: Re. Backup
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Re. Backup