Scenarios that Replication Slot will be Marked as Active = false

From: Avi Weinberg <AviW(at)gilat(dot)com>
To: pgsql-generallists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Scenarios that Replication Slot will be Marked as Active = false
Date: 2024-05-10 11:18:48
Message-ID: DB9PR07MB7180A945D1BD820B838B6E06CBE72@DB9PR07MB7180.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Experts,

I would like to write a monitoring script that will check logical replication running on our setup. For that I would like to know when to alert when I see that replication slot is marked as active= false. I will probably need to know when it is a temporary state that I need to wait before I alert and when to alert immediately when I see the slot is inactive.

If the replication slot falls behind the primary server will it be marked as Active = false until the replica catches up? If so, can the lag size be configured that only if it crosses the threshold it will be marked as inactive.

Will failure in the replica affect the active status of its replication slot?

What are other scenarios that can cause it to be inactive.

Thanks!

IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

Browse pgsql-general by date

  From Date Subject
Next Message Daniel McKenzie 2024-05-10 12:11:42 Re: Unexpected data when subscribing to logical replication slot
Previous Message yudhi s 2024-05-10 06:05:02 Re: Question on roles and privileges