public inbox for [email protected]
help / color / mirror / Atom feedFrom: Avi Weinberg <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Scenarios that Replication Slot will be Marked as Active = false
Date: Fri, 10 May 2024 11:18:48 +0000
Message-ID: <DB9PR07MB7180A945D1BD820B838B6E06CBE72@DB9PR07MB7180.eurprd07.prod.outlook.com> (raw)
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.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Scenarios that Replication Slot will be Marked as Active = false
In-Reply-To: <DB9PR07MB7180A945D1BD820B838B6E06CBE72@DB9PR07MB7180.eurprd07.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox