From: Avi Weinberg <AviW@gilat.com>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Be Notify Upon Streaming Replication Failover
Thread-Topic: Be Notify Upon Streaming Replication Failover
Thread-Index: AddhrZvxPB/kMsOMSqOPtZIp7vvCJg==
Date: Tue, 15 Jun 2021 06:13:51 +0000
Message-ID: 
 <DB9PR07MB71807CC04949A63DF7FCD304CB309@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?iEz4OCMEPvtQOliHxVnAKPoDfY2B0Jav8Qwgf+FUjotOJVBIXAlbiJc0bLUF?=
 =?us-ascii?Q?gD8UxHR+uRfzIau9nRCrdilj3wVG6aBEKDJVVIynBojhb0z7EQ5vf/4CBR1T?=
 =?us-ascii?Q?jcTKZDSaa8jQ4z4X9W8wAw1Uiimshloey5Kivo+gndH3twptOkSPFpy9EQ/P?=
 =?us-ascii?Q?3JKl4RaVoh06cPxo3ft6gcLRqN9eVSH7E1ahrH4AGYoLcm8Ghu+eosPkmdLD?=
 =?us-ascii?Q?W9LoipcH9PHShPuXjBkpM05+uPtRhUgTrhu8XXAgwYYlucolGniHiAL6CY4c?=
 =?us-ascii?Q?4XSALs16wsUxWjxOElWS9o0vE6CBOb81NcGld7k1cs87sq2/OQ1VFWaaYuXu?=
 =?us-ascii?Q?+EVnlAq3VBBJmC/7YbJRLd0if4wC/sG9rUlASHHe8N9BCflkDmCZXmOJDYBj?=
 =?us-ascii?Q?SwPHSvFEVHENOVVo49BpzILPqR+307677nGWT1/qQLDXiorkMEzUUGjVEJJ3?=
 =?us-ascii?Q?0+V1QhUTwlIfvlgKs0ZbTqrflca4+igporTGnMZqwLGPVV/EOt78iu8FX8dA?=
 =?us-ascii?Q?W8e8dS98lToC8YGDTSKelBMtivDI7U8/jXEAQos+1Hu5uZNeh/+Hj0TAfNhY?=
 =?us-ascii?Q?XVz1x6rYtju5pUfH1hC4l8psbiAPBqKTpP7ROYDTpYy39Xse/MEfbDXRASwf?=
 =?us-ascii?Q?4WtSl5vVTRyxpSRnOOzTPAIL4v1x4X2lebosE+S8B+PxCoGA/N9nulre0Afh?=
 =?us-ascii?Q?lyYxKjhi3JTdtwgdaAKpxofZZwolOIuRP29H3uAG02CAiOElSOvzpp2ssvSO?=
 =?us-ascii?Q?VGpZ+N2vmmcPqq+c9ez4EjurSetgr0NvC4g93LSfzD3qCqGHRu6FWvCOHrqG?=
 =?us-ascii?Q?XebpQEZorgLTzTugIAdera6LAfcb7oMRVT5zlfmhavkfVp1NiW2fbAjt73iJ?=
 =?us-ascii?Q?ouupUmNv6+/zHEtx2s4XozlxHp16YJwC171y4mNRlPXkdMrcEqJiduL8aPf1?=
 =?us-ascii?Q?4rNwr30wsVfnNd6hCT5+hCI8mW4wLlAnNwVNgnoUIYb9omeNpPQX5l+9SYEV?=
 =?us-ascii?Q?T2FX5KSn5uwq9c70Gwqbm3Za8f9XP1GYBJGSxv+6TJQCNAaZRyv2Wb+mO3Fr?=
 =?us-ascii?Q?jLz/2QblEXRzfPNCcitblwwdfZvAdRyFytX362hQIGp/GG8vqqG+sYO/R7TQ?=
 =?us-ascii?Q?3qdJFDORY2cpXoW7ao1FcyAnhGfvFvtuP14hgzz5rMKlP1E35Z22RRVvwrXP?=
 =?us-ascii?Q?PK/2PiKhnybcHoyKjtCVLXimhibuAwdRFkqlshukJE+YE6VX9WO8bR3/Qzui?=
 =?us-ascii?Q?bkfT4yrqC4Wb06t3y29EihijW07gvBNoN6GNs7xTtO65R6YzyAahkpUd3g+a?=
 =?us-ascii?Q?g7rq1mefRDmim9YpL7JjHGZn?=
x-ms-exchange-transport-forked: True
Content-Type: multipart/alternative;
	boundary="_000_DB9PR07MB71807CC04949A63DF7FCD304CB309DB9PR07MB7180eurp_"
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: 
 959141c7-32c6-437a-7624-08d92fc4bf65
X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Jun 2021 06:13:51.9484
 (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: 
 8vKEQSZNgeEfL4Wb6YE7qBeIOUwZKJhP7nhyvM5aAuSHJaDtljMI3eOykovRfDIn
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB6PR0701MB2485
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/DB9PR07MB71807CC04949A63DF7FCD304CB309%40DB9PR07MB7180.eurprd07.prod.outlook.com>
Precedence: bulk

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

I need to take actions when Postgres streaming replication failover occurre=
d.  Is there a way to be notified when Postgres slave becomes master?  If n=
o such notification possible, what is the best way to actively monitor whic=
h server is master.  My Postgres  is running inside Kubernetes and the HA i=
s managed by Patroni.

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_DB9PR07MB71807CC04949A63DF7FCD304CB309DB9PR07MB7180eurp_
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:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	text-align:right;
	direction:rtl;
	unicode-bidi:embed;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;}
@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"#0563C1" vlink=3D"#954F72">
<div class=3D"WordSection1">
<p class=3D"MsoNormal" style=3D"text-align:left;direction:ltr;unicode-bidi:=
embed">I need to take actions when Postgres streaming replication failover =
occurred.&nbsp; Is there a way to be notified when Postgres slave becomes m=
aster?&nbsp; If no such notification possible,
 what is the best way to actively monitor which server is master.&nbsp; My =
Postgres &nbsp;is running inside Kubernetes and the HA is managed by Patron=
i.<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">Thanks!<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>
</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_DB9PR07MB71807CC04949A63DF7FCD304CB309DB9PR07MB7180eurp_--