From: "Tharmarajah, Sam" <sambavan.tharmarajah@usask.ca>
To: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Open source HA setup for postgres
Thread-Topic: Open source HA setup for postgres
Thread-Index: Adjf6eb6LoXUBBTWQGu3LGpKp3TlkQ==
Date: Fri, 14 Oct 2022 16:33:50 +0000
Message-ID: 
 <YQBPR0101MB4666077E45AF055E05FF961FF1249@YQBPR0101MB4666.CANPRD01.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?cG+TwBKAitNJR6U8S5RmPZy+mc7rbqE6CyEevvpWwbSlCIwUkenXkRe+tDXc?=
 =?us-ascii?Q?q9aTU7CgHLPWkOvsDF3C6AfVq08Jwsqd/6H0tSQZbEccDqZUedmJ9TvXkePv?=
 =?us-ascii?Q?/G3A/EAzrvzf90+/DKHeA1OcH2hyRGj1f5UTNQK9e5vkSjjEU60zZftNKANw?=
 =?us-ascii?Q?1V0zFxPr16ckvLLVYBceXFBl8Rdv6eEUqvHyj0nrboFmCZMT9dOi4+TMqT1J?=
 =?us-ascii?Q?3dV7KubrqKmNUZchws3Oh4iyD9im/vLaUlikEzynXBDVx4Ul9A6vMLpHLFiV?=
 =?us-ascii?Q?sVa2R6dqajSHJwCMKsdVy8Arj0/FYFXrGm/QOIaxEs6Kr+fK1lrGgKj5yS93?=
 =?us-ascii?Q?9gTryKeynZiP/a4TliR50ZqZ5IDd0SpuCdqeJ1QcLbJRWiLr7ogaG2oo380l?=
 =?us-ascii?Q?iKQUY4jWnjsu8GM/kuMJaiZssLTJaK4HEOE4EfCl1hQOeThUEgHrRM2qUmYP?=
 =?us-ascii?Q?CKt0EGE5/WYhN52FzbfE1o0TBkST1Nyc0Ren1hiKChC1WDIsF2HDpk7/7sBz?=
 =?us-ascii?Q?UozxJjcDez4ZKy9SPA3r82Mc5OXAkvMvLZTehdxxjGzHgtPjORAxr4IZdjru?=
 =?us-ascii?Q?DmG1m1BSReoR5ZSjbKbynFvr7ForJItgwZaorZgxyJf74oFc0dkp6ZRyvSm5?=
 =?us-ascii?Q?so0ZZ7DnlpkX64mSXkFsP8zVMiQauj4+qVnv6FLLsyHLuK+xepKeuCWIAozI?=
 =?us-ascii?Q?BkNtjWP/avRYSd7glEnLoU3bUkQVyyWwV9HsUCGSB35xVn75376l2QHQRKPl?=
 =?us-ascii?Q?tVgPi2KOwgALxUj6eTOHx7D2CKWwDOFgLTisH6qzu/TelX2s8mWKsPJ57BHl?=
 =?us-ascii?Q?Rhb8a6IJIfT+A9P/NfOFrP1j7WsInzaTHOw1aJsFoqeBnpYNedkM/5R3woCE?=
 =?us-ascii?Q?nxH8UKG0dt4xOxtnYOkS7xzR8kWiRSOYUKu6pM5gt1ZB1fh+79blVSH0X9fH?=
 =?us-ascii?Q?gB2ebxb7egaKzyDWSGA30YBZdfHK9t3zhN1bVgN+jXo+oZ2lZZAOxsMkgpY9?=
 =?us-ascii?Q?gzroEfH9kOe0fA1PYIepX99D+TsxXeZvDyS3vef/fu5eXiV/UVWsmIRTVMCE?=
 =?us-ascii?Q?Bp6APXnaZzpa/EwlLnwBcxooewGUk4RUqKa5CdzPXADHmeZ8cwNYEoLNoEt3?=
 =?us-ascii?Q?R1IS3/I9Zo2mmpvULxnvo7Q63MGw3rU9vEE3Xg+kW0b4GboVsQuujEXq4OT8?=
 =?us-ascii?Q?d3b+5B/EXQHzbqomN5uyDMhj8AB6J4vb4LoO0cQDnSsXorbcYGDfr26Rj7i7?=
 =?us-ascii?Q?ExOie8eUX1s7ceFZVt7GjoWbZBlC4g/tFpkN0COjl7hjNGPOfijbtHhZqZy2?=
 =?us-ascii?Q?+8Yq/pC2aA9tsb3vumBgIFIZt3Ym4dfAyBnl1oDxiGLY4ng2OlI/ei6coCKA?=
 =?us-ascii?Q?E03a2mf22Qzw0S/jNPQvpHd6WbLW9fM19NpT9gWaaPJxUQxfUMXvGAYnW/A/?=
 =?us-ascii?Q?j1eBq4vvI2BQN37tt9tCDjOPkZwTe6tEDJGoCXqSHJIRxhRNpGcB/QORPV9/?=
 =?us-ascii?Q?uWbg9Ev6UwGYhmppzekBho1Z3HNhpvtVek9FAefEZ4+q7IeIU9H9rwGqIkGF?=
 =?us-ascii?Q?1boSduMBwoBETVO35w4=3D?=
Content-Type: multipart/alternative;
	boundary="_000_YQBPR0101MB4666077E45AF055E05FF961FF1249YQBPR0101MB4666_"
MIME-Version: 1.0
X-OriginatorOrg: usask.ca
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: 
 YQBPR0101MB4666.CANPRD01.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 98f9e0fc-5939-4e51-c3ec-08daae01e02d
X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Oct 2022 16:33:50.5486
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 24ab6cd0-487e-4722-9bc3-da9c4232776c
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 iog7AtRuSKNMswCc30Kl5v9u5whle0FK3Cd2rs/PSZrOpELGFiYIV1SZKVqmuSHH
X-MS-Exchange-Transport-CrossTenantHeadersStamped: YT1PR01MB8857
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/YQBPR0101MB4666077E45AF055E05FF961FF1249%40YQBPR0101MB4666.CANPRD01.PROD.OUTLOOK.COM>
Precedence: bulk

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

Hi,

We are wondering what is open-source tools being used to set up the HA. We =
are also looking for a way to pass the reads to all the HA nodes and writes=
 to the primary.  One of the pressing criteria is the HA also should be abl=
e to handle the node being taken down during patching and should be able to=
 fail back or recover seamlessly without any manual intervention.

This is the first time we are embarking on HA, so would like some advice an=
d caveats to avoid.

Thanx
Sam

--_000_YQBPR0101MB4666077E45AF055E05FF961FF1249YQBPR0101MB4666_
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:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;}
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:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
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" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">We are wondering what is open-source tools being use=
d to set up the HA. We are also looking for a way to pass the reads to all =
the HA nodes and writes to the primary. &nbsp;One of the pressing criteria =
is the HA also should be able to handle
 the node being taken down during patching and should be able to fail back =
or recover seamlessly without any manual intervention.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">This is the first time we are embarking on HA, so wo=
uld like some advice and caveats to avoid.<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Thanx<o:p></o:p></p>
<p class=3D"MsoNormal">Sam<o:p></o:p></p>
</div>
</body>
</html>

--_000_YQBPR0101MB4666077E45AF055E05FF961FF1249YQBPR0101MB4666_--