From: Avi Weinberg <AviW@gilat.com>
To: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Scenarios that Replication Slot will be Marked as Active = false
Thread-Topic: Scenarios that Replication Slot will be Marked as Active = false
Thread-Index: AdqiylWLAwWu8JAfScytkEJWcwacmg==
Date: Fri, 10 May 2024 11:18:48 +0000
Message-ID:
 <DB9PR07MB7180A945D1BD820B838B6E06CBE72@DB9PR07MB7180.eurprd07.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?YAd6WDnJdLgsef8t7s1L4Io6K9/MqOuMAF+ZAHTEsgFf2MuQwDIxg3EWGlOj?=
 =?us-ascii?Q?/hw/FxET1ANLfKJpGb9m4vOaDtv5vlTF44wC29JlKgmsXOALbzzdIzTXxmm9?=
 =?us-ascii?Q?YR9FJumQ+Gx3+QIgkD+XZ6bEdRwY5dIyk30XBhe0o/Bxa0ELge6WwKWl2duN?=
 =?us-ascii?Q?ZeBunBFamzxcMbl/W84rDw9tBUU8d+ILzCPgkA1CrBdLmtxy80icWWZBylKg?=
 =?us-ascii?Q?GHuWOKm5cmkhsaFNrKc5mZfOQ8p5KbsFt10xGe8pxWwqUJkflbP/fWkQ66lb?=
 =?us-ascii?Q?hNJRMABdD7kpk/8fRdAWAP3nSf+/4ugFbQtQoihN+qR1Cx4abjes6xb04x/J?=
 =?us-ascii?Q?0jVkdKMRzVvcl9H6j8e22QYv5PPQxh/yyvOn6yRTaHmmKyhPUpBPdeKlfdGJ?=
 =?us-ascii?Q?KEB8/NU69jUgDCHUj/Kc5elgxZFK71kQjY+g8A3h2R3No5sXOzrhIdCZJI4O?=
 =?us-ascii?Q?297QtTwPmzvWb956Mhnx7DoLVcE+mviIfMu5mTRd/aECer8AB32dlYjLzDcU?=
 =?us-ascii?Q?dwOaiwIXas9fTFzUriGfDdLeCDm0LvDUNhdlG/jGR4Y7yUazoxkFWxjuSMr/?=
 =?us-ascii?Q?aqJJmhW8TkJkPwoIEJPx6QxPRsTBUqm9+QRGukAYenWH/W1jSIgvSl3T3kcT?=
 =?us-ascii?Q?KD2xYFPNO0s710NqA607anCEePMXCHxLCZ7oBUKDQlhR4wr+/0kOHWZ3ivAS?=
 =?us-ascii?Q?XIV7N1ssLF3PB0J2BqkJOzlMCRKeig/j/Ye/mb83hjjtGH5aa4HB5AxvI7d3?=
 =?us-ascii?Q?hJ2N7vD8hvqe9yC8cV+TgmFy5QR1gCibd7DImckd/7p7Vv2i8Vgfdw5Mnyau?=
 =?us-ascii?Q?Q/LCjjemm++7dktbj0Bdj3yXC4fzrG8cQx2h7Bfd8WT6H0UYlu2UbWziTbJ4?=
 =?us-ascii?Q?Cly2Pp7sPThMweCYwD5t5+kn7Gf+28yPQ9mNxxHGR54FIOVi6USF26Q4nglz?=
 =?us-ascii?Q?TAUGQ6aas0HDlmuM3T8mPcCdGHf4gchCchHeXJK/2DeX85lOFL3URIAab/eQ?=
 =?us-ascii?Q?o6HreBkC4alsFb5uzx8Cdda6SzGbF1MnjBmEZDbiCwvgt9+2DUiNuZD6XcCa?=
 =?us-ascii?Q?eEXPa+NL7jCRqJsBcne7+ZIt2SWr1kR558jH/BvXIjdcq7h84k5qN2JmifQb?=
 =?us-ascii?Q?CqqmcWIK+H9+GQVHzQ3PeqvlL8GyP7iBnWgsxBxvpzSD7TPoG6sT8I3r82pA?=
 =?us-ascii?Q?x8uyqJfZVvq/EWIdk4AJO3t2hl31qkqSy50cSeDbnr3L4kmGSL0YJQ7dy82N?=
 =?us-ascii?Q?8Lq79PmJw62sYia7uvwzhMMHLdTN3T8d+JqIh1gmp6iz79dZe9wYonw/ht0B?=
 =?us-ascii?Q?t+dWa2MXBVQVydziM4M/4HRYyQ2QUjBFzyLWX217gp4Rdz8IZy2wIAJWQR16?=
 =?us-ascii?Q?LTjc+p6KKZ7R6UFPbMzAwEHSYRZvwQha5GUUrHsFaunK7JVsYTpiQUN2QwW5?=
 =?us-ascii?Q?sPWZfAiYP7dcuYtV8u8hZ5zSj0XvnqpVBfi9C56diqYUOEu3PPJ8EhE6ji8N?=
 =?us-ascii?Q?nDhdYDx/Wr8mM/d4BpL5P6/wEFA++1Xz0ePaKn//uztIIo9QtD1XbrjOMSeN?=
 =?us-ascii?Q?3KYLHZdXRLkW3AVtmBU=3D?=
Content-Type: multipart/alternative;
	boundary="_000_DB9PR07MB7180A945D1BD820B838B6E06CBE72DB9PR07MB7180eurp_"
MIME-Version: 1.0
X-OriginatorOrg: gilat.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DB9PR07MB7180.eurprd07.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: a08a8ffd-b3f2-4ad4-2f0d-08dc70e2f6ac
X-MS-Exchange-CrossTenant-originalarrivaltime: 10 May 2024 11:18:48.2606
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 7300b1a3-573a-4010-92a6-1c65cd85e927
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: Zu6Ely6mq0/QRFF+kYJFBXVny3z2uXCeAywgiDwMKz1HsNH27RrHVp2PIJzi9uFJ
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DU2PR07MB8254
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/DB9PR07MB7180A945D1BD820B838B6E06CBE72%40DB9PR07MB7180.eurprd07.prod.outlook.com>
Precedence: bulk

--_000_DB9PR07MB7180A945D1BD820B838B6E06CBE72DB9PR07MB7180eurp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Experts,

I would like to write a monitoring script that will check logical replicati=
on running on our setup.  For that I would like to know when to alert when =
I see that replication slot is marked as active=3D false.  I will probably =
need to know when it is a temporary state that I need to wait before I aler=
t 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 a=
s Active =3D false until the replica catches up?  If so, can the lag size b=
e configured that only if it crosses the threshold it  will be marked as in=
active.

Will failure in the replica affect the active status of its replication slo=
t?

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 privileg=
ed. If you are not the intended recipient, please inform the sender immedia=
tely and delete this email: you should not copy or use this e-mail for any =
purpose nor disclose its contents to any person.

--_000_DB9PR07MB7180A945D1BD820B838B6E06CBE72DB9PR07MB7180eurp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Aptos;}
@font-face
	{font-family:-apple-system;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	text-align:right;
	direction:rtl;
	unicode-bidi:embed;
	font-size:11.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle18
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:11.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:none;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">Hi Experts,<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">I would like to write a monitoring script that will check logical re=
plication running on our setup.&nbsp; For that I would like to know when to=
 alert when I see that replication slot is
 marked as active=3D false.&nbsp; I will probably need to know when it is a=
 temporary state that I need to wait before I alert and when to alert immed=
iately when I see the slot is inactive.<o:p></o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><span style=3D"font-family:-apple-system;color:#0D0D0D;background:wh=
ite">If the replication slot falls behind the primary server will it be mar=
ked as Active =3D false until the replica
 catches up? &nbsp;If so, can the lag size be configured that only if it cr=
osses the threshold it &nbsp;will be marked as inactive.<o:p></o:p></span><=
/p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><span style=3D"font-family:-apple-system;color:#0D0D0D;background:wh=
ite"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><span style=3D"font-family:-apple-system;color:#0D0D0D;background:wh=
ite">Will failure in the replica affect the active status of its replicatio=
n slot?<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><span style=3D"font-family:-apple-system;color:#0D0D0D;background:wh=
ite"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><span style=3D"font-family:-apple-system;color:#0D0D0D;background:wh=
ite">What are other scenarios that can cause it to be inactive.<o:p></o:p><=
/span></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><span style=3D"font-family:-apple-system;color:#0D0D0D;background:wh=
ite"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><span style=3D"font-family:-apple-system;color:#0D0D0D;background:wh=
ite">Thanks!<o:p></o:p></span></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><span style=3D"font-family:-apple-system;color:#0D0D0D;background:wh=
ite"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed"><o:p>&nbsp;</o:p></p>
</div>
IMPORTANT - This email and any attachments is intended for the above named =
addressee(s), and may contain information which is confidential or privileg=
ed. If you are not the intended recipient, please inform the sender immedia=
tely and delete this email: you
 should not copy or use this e-mail for any purpose nor disclose its conten=
ts to any person.
</body>
</html>

--_000_DB9PR07MB7180A945D1BD820B838B6E06CBE72DB9PR07MB7180eurp_--