Instrumenting stale replication slots - Mailing list pgsql-admin

From Joseph Hammerman
Subject Instrumenting stale replication slots
Date
Msg-id CAHs7QM888FG=Ndkwa1rZjcOC=AWuWmiFroyUkEuP7Un9O7frwg@mail.gmail.com
Whole thread Raw
List 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 by date:

Previous
From: Sushil Shirodkar
Date:
Subject: Re. Backup
Next
From: Laurenz Albe
Date:
Subject: Re: Re. Backup