Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rOKTE-003HVm-A9 for pgsql-admin@arkaria.postgresql.org; Fri, 12 Jan 2024 16:33:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rOKTD-003Jlf-CU for pgsql-admin@arkaria.postgresql.org; Fri, 12 Jan 2024 16:33:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rOJW4-002mmL-DZ for pgsql-admin@lists.postgresql.org; Fri, 12 Jan 2024 15:32:16 +0000 Received: from mail-yt3can01on2090.outbound.protection.outlook.com ([40.107.115.90] helo=CAN01-YT3-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rOJW0-001Crq-Nf for pgsql-admin@lists.postgresql.org; Fri, 12 Jan 2024 15:32:15 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=FKh+UQ7VEnUlRIVLcI5O1KojE1znR1LLzuodObaS0JjalP74cq8ZcqvuHYgs8ielSUNVpNd10s0kep0ftRDNoKtRA4mvD7Ex7Kp2WYi1Plvfa93/gq/AJzVWoiFxxZfsk7i+APyVVGrlP1MbiasqGvFbEREpIDWRKtHhTelW34P3Au9A2O9l8fi7x2/WfVtPY5iWc/BSA2ofHctUFCH1hoZ1LU1XCPEg9hyV05BVm/ImwiPeAG+nwUjEReOBkmmIxwpxj/gjwL2f+suTVn84ByQyeR8yjLe2BCqKaAeIXK9PyazPoH7DHy7v+hq92ozjCdi9LZAwjTPjY3cThzxT2g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=41daAUOWgcfsxoBbg6SIpcea0hRJBb2XQbJmzXvJyts=; b=ijoOY7GapwuiR0H3fMPefz2AMC4KcPT0Nr8140XHtEdmFN9TTOfDoXH78KIY5Dn5rcH1FO1mkBWcVC80cOHiJXk300+eM2UnuQmXKLKYEKw2cUSiu8n+0S/iP6ZGySNlOyIiGoJMqxvg9qdC4EDAw5mJHoKaFO83xHi9+nUqtJuEdnrzDpUaSCvI+c8sEW8Zvb70mLwAO+pDBmawYUf3SpTagFlvoNBtn2SPYU8BZgJkRsianhIyxwAGFpRjkKvCKSMN9w+bnoME5ey8WuoDsfeTBk6Vx+V70kJqFQ5ctKDFXy21NsWOaKJgL/h4Eu3eZJ3jBOLUYrrGNnlt5IuaQw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=usask.ca; dmarc=pass action=none header.from=usask.ca; dkim=pass header.d=usask.ca; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=usask.ca; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=41daAUOWgcfsxoBbg6SIpcea0hRJBb2XQbJmzXvJyts=; b=qmRD5DRxszhWLrt5O9av9vQHpinv3MTzKpueCYcbPI/ClUXhS6l53MlR/pDBXB5nHzipN9JbU92V1CNs7ewT7WGGl4rdPyyHtCpIjYCb/hsAYipyQso+MYxPfQ2cpHNU//N4s6cCmjHLoYdKUjnPae8XFSQb1aAdIhX1QFNkxQFwSdzA8XbHPVltQ7jMtvGN/fOorCzgk4QOLUzJB2VAyGuXSxckNJll/76sB7rVA2h9AIfMdfjuwUBj1SbOsf8yWg91FvzCkIvrNRq2ALezwNIkIjkNu0x/+L6tmr33qNSUVGezhnZUZCmj3mjGT9MBrjdBbjdv5SlIIcYAJMumFA== Received: from YQBPR0101MB4666.CANPRD01.PROD.OUTLOOK.COM (2603:10b6:c01:15::12) by YT3PR01MB6408.CANPRD01.PROD.OUTLOOK.COM (2603:10b6:b01:74::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7181.23; Fri, 12 Jan 2024 15:32:08 +0000 Received: from YQBPR0101MB4666.CANPRD01.PROD.OUTLOOK.COM ([fe80::4aa9:9ce9:e507:a772]) by YQBPR0101MB4666.CANPRD01.PROD.OUTLOOK.COM ([fe80::4aa9:9ce9:e507:a772%4]) with mapi id 15.20.7181.022; Fri, 12 Jan 2024 15:32:08 +0000 From: "Tharmarajah, Sam" To: Jwiencek3 , jacob ndinkwa CC: Loles , Zhaoxun Yan , "pgsql-admin@lists.postgresql.org" Subject: RE: How to configure Repmgr Thread-Topic: How to configure Repmgr Thread-Index: AQHaFv6Rtj6DgH+bi0GSbT3GzQ9UpbB7ZH8AgAACvwCAWyBvgIAABbkAgAAGMgCAAAXlAIAAELCA Date: Fri, 12 Jan 2024 15:32:07 +0000 Message-ID: References: <7C5C297D-B74C-4527-82E4-34A215E43060@comcast.net> In-Reply-To: <7C5C297D-B74C-4527-82E4-34A215E43060@comcast.net> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=usask.ca; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: YQBPR0101MB4666:EE_|YT3PR01MB6408:EE_ x-ms-office365-filtering-correlation-id: ac825f55-4d12-4e1d-3e57-08dc1383a346 x-uofs-origin: Internal x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: IJkKJUIM3LUm12ikLYEh9pT29yh8sHP/A/kS4+UXPEGyRos6agAzbqS8lryA8pv+wJbiLNNxeimACNN+dRbxX5T03MYdMvWxJTdieF7jFghGFa9VwMFrKbH4dDhUhY1dewBaBvyyqBbn1YrWHyfLlucN4BqatRztdwz6J2vRDT3G6Zwnaf1LaeWvJq/Jaf1oeSqHb6pGEy7QSLEm2lMq2kKB+MOPzPmh4dWCZIF45qPkeAr7F59v5K2TQ5nKSGnScW0kBnyAIJM/Nnd1cIlqGzks9kIDMBmrQOB5TcJ2g0vSDnxFnM3pPFBCiKOx7NT8CYbmlWorXW+ImLruwbFxf9q649kmIgdJM17UB2ueYiO7kiRn7jNLy5+RmrkrhwiobIUI7DPRvpdO2F5CG4YwZUVGM1bR1bFjhYrGfefx6Q+2J0SzaDFgYswVoqlq5qnzA3oPNwVmtM4U+4p0S0EpGugDaj+eCXKXJDNZIRBgRQfTOoA32llJOwiZtHhOShk3V3wO4PPoIAdLFBWESz3Hk+cKPEnEzvu3/xZ1yr68WrRa1RnO1cbKuhN/5CI5nCDjuWCnJ21cziqLpKK9021Or1GneU406/63CCk4cvgCrIFyI1xHXAjWSST3v2tP6UlM x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:YQBPR0101MB4666.CANPRD01.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230031)(396003)(136003)(366004)(39860400002)(346002)(376002)(230922051799003)(64100799003)(1800799012)(186009)(451199024)(64756008)(66446008)(66476007)(66556008)(4326008)(52536014)(66946007)(76116006)(7696005)(3480700007)(71200400001)(558084003)(8676002)(8936002)(86362001)(33656002)(38070700009)(110136005)(316002)(786003)(54906003)(55016003)(478600001)(122000001)(5660300002)(2906002)(38100700002)(26005)(6506007)(41300700001)(9686003);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?49fmnIitiWRERm+Mx2neu0VgnJP7/txo53RdMoyeMv+2JbyGd7qYCqCtMlvK?= =?us-ascii?Q?dAY3/0tHlmKLxn21pQhsStIdFmkXDPl5NYotRSGev/myRDye82s8OhTz1PtY?= =?us-ascii?Q?7jY90DBP9IQnZt+agfQQELoLI+RvL1xVzWVUEVebLBv4Cm1SOAD8cHMk2HUc?= =?us-ascii?Q?G2adiPZONxuj16xRgCbXIatOujQ8Q6UA7MwtPeho2RhgtTOx0SpzchIQfP3z?= =?us-ascii?Q?2nSl55uHEOyfmIHEaevZd+kUu/zM/FS5ym9YouHWDOCX41IqYb6vZoABbc5Z?= =?us-ascii?Q?uk5Anb18hAAHtif2IB1B0MI+HR0d9sOR+wN4t6l5GNIkCUP8yHO6Vo0jTZwv?= =?us-ascii?Q?fC4cVTRcQq9KtjTGVaeyfP1bm7NChdM2i1U3WSGvMJQPMcMVYLf2tiS4e7U4?= =?us-ascii?Q?RigIgh0AvslOZf1cOW6EqT//w+eMQxyFuex+liP2fWly7iPVtypvn6aFWcwY?= =?us-ascii?Q?LJPt/AFf3JMb47xIUUGRiuerB9shN7+Ck1OqjVKzPxjWGwMg0BGZJL12vUeT?= =?us-ascii?Q?OZ7vuo9xaPabs17VvIE9+k/o00iSHPHYfK38V1VxMEmHpJ3ppwIjIRjS5tx6?= =?us-ascii?Q?GrcRuLPl+hE1PMI9hfT0LlC3yZom2AKcwVFFmUxG+fEX+83RdDnSmcuDTnHy?= =?us-ascii?Q?6sdZcj3fmpsA2KPs0Fd9zQcQbYJQe5DFDy+vZhBa+rncAPirOGMPLhW7uu9M?= =?us-ascii?Q?pZ6wmOOUQYlp4CJmwhxpBD1KSthXK4aSwLsla0k6IYCd8n2bgjUFpAJR2tMO?= =?us-ascii?Q?25u2XWl4iIwMaqMFbs51opJUm9xDWc9RCnlBSQZLoerPA/zd2VcxcmDfpTfm?= =?us-ascii?Q?9c5WNdkeHn1Y84VV7J0yqwqfloHpGIN73sX7D71ZxmOikw2wSUrgNGg1zBJs?= =?us-ascii?Q?1DdRUv8awezcj3y/mihtLrVe/C4Bf3kh1AWeGgTWvoEuzKGML2FeFvVzdRoP?= =?us-ascii?Q?Dyk0rRt5XG/RDPJs5br94OC8uFRcnY/bnaTfnx5HnVDxCCn4sCFF5WRbZm3A?= =?us-ascii?Q?VQOhrE5S3Kym/SIFDahJT1q1279pkfewmyWzUcNwSK9E7jtTiGD8S5snAP6k?= =?us-ascii?Q?lsTzOljR2xXrByMdR8ZAXbA5v1hzPUEz3Ufmbxv+B1X3qS8qBefEQo/XC9HM?= =?us-ascii?Q?/Pl54EdS+kn7fh/JDlDH41MksDRgYWdb24hepBzr59EsIEHX4V64CvEqpkzm?= =?us-ascii?Q?+6nXaU+MAK1OGiJVhGjvt/0mekO6NvHPi6+V9M9PhCtEIUH88aOg6SynHwJB?= =?us-ascii?Q?opwYZ6iO0huZB1K3s9W8qs+r6Ex7UpZG9fA2CeTWDxW4xRMIUYnMZcT0hyw2?= =?us-ascii?Q?SJRvqG/DOzyMjYl5oGVchCPg47LKPv282saL2lodfCNnFZ+7PhvzRjI+FlKd?= =?us-ascii?Q?pJt4r/spf5OoADSZ9eYqq7XaLie9Ft2au4F5JDukzOy6tRHga1fjGUXqWpLs?= =?us-ascii?Q?GfxbYpAUm4GRcLF/KYO5BBPY/+ED+Sx1OIHRLr9R1slekL/z9AXCnGJRP15P?= =?us-ascii?Q?7tZ4Quzo15eTFSR5AZeMg1Q3TuOfasn+w/P+SVi2TTzR0oF2t7VVPX7+df6i?= =?us-ascii?Q?gJHaeaj0hjsW3B/IGKw=3D?= Content-Type: multipart/alternative; boundary="_000_YQBPR0101MB46664C12029E6126CB6EE33DF16F2YQBPR0101MB4666_" 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: ac825f55-4d12-4e1d-3e57-08dc1383a346 X-MS-Exchange-CrossTenant-originalarrivaltime: 12 Jan 2024 15:32:08.0327 (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: m5AOgRqGS+rGlyZ37e8laWlSJl9Yi9Dnk5GKX+kH67zqodS5S0dNPqpIGHiMXKAf X-MS-Exchange-Transport-CrossTenantHeadersStamped: YT3PR01MB6408 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_YQBPR0101MB46664C12029E6126CB6EE33DF16F2YQBPR0101MB4666_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Not sure of the purpose of going with repmgr. We have been using repmgr and= my personal resentment with it is that every time there is a network issue= , we end up with two primary and manual intervention is needed to overcome = that. From that regard, my preference is Petroni. Good luck. Sam --_000_YQBPR0101MB46664C12029E6126CB6EE33DF16F2YQBPR0101MB4666_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Not sure of the purpose of going with repmgr. We hav= e been using repmgr and my personal resentment with it is that every time t= here is a network issue, we end up with two primary and manual intervention= is needed to overcome that. From that regard, my preference is Petroni.

 

Good luck.

Sam

--_000_YQBPR0101MB46664C12029E6126CB6EE33DF16F2YQBPR0101MB4666_--