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 1sk1Li-006o2k-N1 for pgsql-admin@arkaria.postgresql.org; Fri, 30 Aug 2024 13:07:35 +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 1sk1Lf-004644-87 for pgsql-admin@arkaria.postgresql.org; Fri, 30 Aug 2024 13:07:31 +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 1sk1Le-00463w-OT for pgsql-admin@lists.postgresql.org; Fri, 30 Aug 2024 13:07:31 +0000 Received: from mx0b-000e5c18.pphosted.com ([205.220.181.92]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sk1LZ-002Fg8-KD for pgsql-admin@lists.postgresql.org; Fri, 30 Aug 2024 13:07:30 +0000 Received: from pps.filterd (m0285255.ppops.net [127.0.0.1]) by mx0a-000e5c18.pphosted.com (8.18.1.2/8.18.1.2) with ESMTP id 47UArjtG024140; Fri, 30 Aug 2024 13:07:24 GMT DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mdlive.com; h= content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to; s=pod0510241234; bh=U1VTjPcsiBxX+Ui+4TZS 5dPSWM2mEyYy8/DTHT9fqEE=; b=Kf1oU3MHg5m0/Y243Ey+AYN/Y367p+xGqSVo Nlm2RgcgrYebop6VfAqpwvpz1iIuhfOVfEn7lZXKxq/K9c88kMSRW77tcc0iLN1P OStaQpxs9cdEsqof4twd8ZsGreb6SANHd5aDTk+lr5HnEzSInN/kUntuBCl3VfA+ jdWq1MQ9tudwu6/IgXI22VS5tNe+tWhGl/vG2sYp5idx76fAl2JVzqGWLjjUZgLW DdolVhRx3tDwk+QK4wocx49mE4RjgFuoIiX+Ib0XcAvDVoVb/PWUZ1unnCskpbme 4+JQVD4UAnR/2y6TW3kpgWzPWRZtVKRGuQF9MVPwoDUMMRxrUQ== Received: from eiaappxp0010.gid.prd.globalcore.com (lyncav03.cigna.com [170.48.19.149] (may be forged)) by mx0a-000e5c18.pphosted.com (PPS) with ESMTPS id 419purmmsy-4 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Fri, 30 Aug 2024 13:07:23 +0000 (GMT) Received: from cvlappxp20771.internal.cigna.com (HELO CIWX9MAP0065.internal.cigna.com) ([10.31.88.212]) by EIAAPPXP0010.gid.prd.globalcore.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 30 Aug 2024 13:07:23 +0000 Received: from CIWX9MAP0086.internal.cigna.com (10.25.171.158) by CIWX9MAP0065.internal.cigna.com (10.25.171.133) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11; Fri, 30 Aug 2024 09:07:22 -0400 Received: from CIWX9MAP0059.internal.cigna.com (10.25.171.127) by CIWX9MAP0086.internal.cigna.com (10.25.171.158) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11; Fri, 30 Aug 2024 09:07:22 -0400 Received: from NAM11-BN8-obe.outbound.protection.outlook.com (10.120.223.5) by CIWX9MAP0059.internal.cigna.com (10.25.171.127) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1544.11 via Frontend Transport; Fri, 30 Aug 2024 09:07:22 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=lKQrEx0kSuMzpIilkB+q3YEZsEWP4AGeg0zBbVs5solAGoZxiqw3IhyH34KfqPfiNi+FKbKX//kRgoYNpOJCU/vkM7YuxB0w0/zErGTHUhXFrag+kFmEvOufHIzZkVJhu7JwPURQ7r5+yIEws2Xy+IsYM4gwQk3nViFbgoy7Uhk2Q3jPiOkFIUIHv9yKf4oR1kPJZppL+mjUIuAHjiAaSS7FeMhiSOn3ANO8gOtFoV5BkQxlgIEl651V8Shg2gCozYq+S8HA92FTl8vYr7RYt5Dw2mexSb3OTCS9LdGFNh+wkZfR/Zsur+FE96ElOVIvl6SfbKArJXUtAs58oL5vYA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; 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=mbqDqjAmfl9dSHsRlxWCndwb4G1g0rD293w8c0otJnQ=; b=PJOPp5vOXh6/La+qb7OvBziLTnxd8ptBDNAhPvnBVfcqv/m/qAvY78l0beLMSt78d058S58Bmzxmrwzin5ahUA/itsKI12BkOl+Dz63T2+WqNkSYFd29yPDI8wHQdeGbCIoXcsuVUXOm5Be6lKoOXr85IZuhJV5D0WkuciHO2UgvgqPImSp2FCTA0RA1AYgbB+BbkIq8YMWrwQzV7DHzIXdHolXvV+Qgk76SB5z/6XiCJW88/P92KuEGO45YoD4q2/aSbN+VAX45QSu1NGmv/eu1YxzjbZNSH1zmxG3XIonR8GTSt6vIjuJst1pYhqZ1+pZgh95Y87jl9QzCqlzD6A== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=mdlive.com; dmarc=pass action=none header.from=mdlive.com; dkim=pass header.d=mdlive.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cignatlp.onmicrosoft.com; s=selector2-cignatlp-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=mbqDqjAmfl9dSHsRlxWCndwb4G1g0rD293w8c0otJnQ=; b=ktBwApLOouaMEn+zluKhONt3A9zKhHEkzGqlcXoX4WueL0anJGmGiYMXHfin0SOTP9rGVkyoICqAU6F2656wba3zbYO7tm9UKZ/eLXlUWYmYAFyJfLR8Acz1tWLzL9JWTCw3duuegs8BU78/mlQQeJdqQlC5WbywDSZgMmoc55Q= Received: from LV3PR12MB9332.namprd12.prod.outlook.com (2603:10b6:408:20f::14) by LV3PR12MB9439.namprd12.prod.outlook.com (2603:10b6:408:20e::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7897.27; Fri, 30 Aug 2024 13:07:21 +0000 Received: from LV3PR12MB9332.namprd12.prod.outlook.com ([fe80::c67a:4999:bfb9:cf1b]) by LV3PR12MB9332.namprd12.prod.outlook.com ([fe80::c67a:4999:bfb9:cf1b%5]) with mapi id 15.20.7918.019; Fri, 30 Aug 2024 13:07:20 +0000 From: "Wetmore, Matthew (CTR)" To: Rajesh Kumar , Pgsql-admin Subject: Re: DR set up. Thread-Topic: DR set up. Thread-Index: AQHa+tLLRsYcQerYdUu9v0WZ/bNj1LI/UBkA Date: Fri, 30 Aug 2024 13:07:20 +0000 Message-ID: <2BEE52EF-8595-4DA7-AAC2-096354CBE2EA@glbcore.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: LV3PR12MB9332:EE_|LV3PR12MB9439:EE_ x-ms-office365-filtering-correlation-id: 821e462c-061c-47fe-f606-08dcc8f4aeb9 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|1800799024|376014|38070700018; x-microsoft-antispam-message-info: =?utf-8?B?bFhzdzJ2L0s4c1ZpdEdTaU5DR2twUDVLUkxtZmtpcmFXTXZLa3dxQkxFYlhZ?= =?utf-8?B?Z3ZmQXMvU0IvbE8zOGJXYjhwc21abHpjWmthWkJTc0hjUmhONytNU3RnUk1E?= =?utf-8?B?Z0REcXRmanNSSGJqcWd3NXlINk1PZUJkTmRra3B1Qi8wWjRLSGZGV3BQc01F?= =?utf-8?B?dTVDcmVTRHp0dS96cE96dERBNURsMlNuRzJCMDlmbEI1Z3RialFjY1pHaUxz?= =?utf-8?B?empXZzY0YjNHLzBzZ0Yzczg3aFZGOFhucUFzazhpRkhkVTlVMHFVRlF5eWtQ?= =?utf-8?B?bWEwL1FaZ2FBQ2ZUeFcxYTRrWjZseXBHQ0RVR0dzbXdYbTRpSk01ZmxQL0tt?= =?utf-8?B?Y201MUpsTVg5K295N1doSzIxOFg0ZmJNZlNGeVh6TTNvS1Mrb05vUkFFUi82?= =?utf-8?B?QWo1U1BCc2o0aFBaemUxa2VrQlRpN29BU1htbGNQVWFXRTRKMjRHMUU4NEIw?= =?utf-8?B?ckpuRFFzT1hYWFFTZE5TVEVKOXNIL1pOeUlBYWN5bW9sUWtCYmQvNGU1c0xR?= =?utf-8?B?S3lQRGNSZjlVSXNjNXAwSjg2L0dFbDQ2YStMQ0wxQkxKcmZqVTNkZlRsUy9Q?= =?utf-8?B?ZUZISkRaTDFwQkpNRmt2TTZ6Y2Q3MitZcUxpdEhlRVd5WmNZQ2VIVFlrbHZi?= =?utf-8?B?d3cvQWlzaGdyV1EvTStQeFg5ZlFMVmhHMng3a01LUDhpK0ZzZUhzamNwblZs?= =?utf-8?B?MWh4eXVTOGhrVUZoZ0xzVFk4ZUk1ZE5YSlNDMHhpek12YUVNbkExVHU5UkFQ?= =?utf-8?B?alhJVHB0cWNhMmhCU3owV1ptVUl6QkFBZ0RpVThXK2FPOUJiMmg3WGNTVlJM?= =?utf-8?B?aW1JV3NHSHoxeU9IWW4zeGQvdkowMDlXWDNyVGdXZTR2U1J5aXJ3K3llejMy?= =?utf-8?B?NFBndHNVbU5lYXlqUUY2YktIcy83RHRmSGp4NGppeEt2b3VhTW5ZYTMrVzY0?= =?utf-8?B?RkZlS0tENWFPZmxQRG1mTWUva0EzUktRZXUycW1YN2hDU0I3Lzc3S3YwZlQw?= =?utf-8?B?TlYyQ3ZYNGlqN0dJUTIxOHdUNE9zWGFBanlTTTZ2a2dkNHFndXh0VS8weG5a?= =?utf-8?B?dXZPSHVnaWYxdHp5c1FDQkdqTXJNZ1QwbkU4YzUvWTlDWGZpU3I0cWF1dkZL?= =?utf-8?B?SGlyaGdaU2ZVMUt2WkxRUi9VZmxLYWpmN1JiT0pvSndOVHJkejMxcjJyc2p6?= =?utf-8?B?V2tsWktGTkpTZjlIT1JMTW1INGxkVkxvcnVaMjZxWHBaNnpoY3EyYmIycW1a?= =?utf-8?B?OG1aU2VNdzlPY3ZSYlE4djdJc296VnlEa1BBQTJ2UTJyb3RLNG5NS0x6WllI?= =?utf-8?B?L2tOZVRMeWRZU1E1NWNDMURrblFlVFQwTHNpTW1KeVBIYVFTM0ZRMkpLZWxz?= =?utf-8?B?MlphOTBCWXp0QmxWK1U0SkpkRzRwTHZQWmFGVi9LOS9EYzc1UGNpakNvK3R3?= =?utf-8?B?Y0JXN1A2akFwVTZ1MFpHME1ZaFZYb1pHN0dpSEs3SHAzMnNleWsxM2tXWExv?= =?utf-8?B?cDJFS3hib1JjVzNPbjE3ZXB2MzBXclN3WVJZZDJjTUwvOHVkSnhyOHE0MkEr?= =?utf-8?B?UDJUMWloWi9RbUtIbWJEeDJmaEoxS3NScWl5dmEzdlFYbmdKUnpFcC96SVNY?= =?utf-8?B?dk9TZ1EzQ0J6OXcybEcwMUZGMGFSQnZHb2FWL2NnV1lkekEwanhvWWpVajJl?= =?utf-8?B?UFZ1WHNCcjkwYit0cVFnNytvTmJsWXUycnV2UFZqb0VpNmFqL2EwOTZ5R1Bx?= =?utf-8?B?Z3RWWE0vSitIUjhnalV0anNiSVJEYks4ZjJ3bEJ2a1FPZXc3Wkh5OFQyWWlB?= =?utf-8?Q?eU941m4aUbmieFX/DcIfr1RgRDlRIYtH/wwYs=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:LV3PR12MB9332.namprd12.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(1800799024)(376014)(38070700018);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?WW51dDVscjdVNWxkK0lIa0t1MTZPYzhQOXN4WldybnBEc0R3ZEFiMWkyZERn?= =?utf-8?B?ZFdhbnowQjNma0s5RWpTR2RVZFVWcHRZY0JDc2pSdXJUK0RLYzFLRjFIWDhQ?= =?utf-8?B?bEFnYjloMXRLMzNhTXRBTDZuYjFMRkFhN0prVTZLVmhZYVJVbHZtblNhVjQ0?= =?utf-8?B?Nk80bHRNcEVYVENNa3htNE4yY0VnRGxLOThCdVo4VnVPcHQyOU1IM0dPak1n?= =?utf-8?B?dzUyWUhzYVBKMFoycDFOTU9mVVM1aWh1NUdyM0xnbmljcXF3TU5JYk9PS05D?= =?utf-8?B?S0dWc2F6bkduSnZWaGlSVWNyaDFJbWIrS2tneWxRVHUxeVRRRGNwandmU3FD?= =?utf-8?B?UE4rV3FpUVd5RHdmN1JmWHQ4Nzllc2dJZVpVOHROa3Z3UEtSQUV6Qk1PSjZa?= =?utf-8?B?NjBHVEo3ZVFNQkRObThHVUdEMFNuVldVUzVSZzFDU3dVZjdla0FURnBjdm9W?= =?utf-8?B?OFdDRVg3ZStyelBUM0daNFQwLzYvRDhaKysrTjBVK1Npa1NJNzNBVDdmV3ZQ?= =?utf-8?B?UElxbmJqR1lHYWNCYTg5NzhIQTF6NmJpTHd3ZnNUK2ZtbzdjdDYwM1djZ0tt?= =?utf-8?B?aGtYUnliT1F4UHhPekwrN2hQdkJzV0Y0Z3p0Qkx1MWVOb2NLaHJMYlRua05j?= =?utf-8?B?ci9ZY0hjdnNMbkwva0JMbHdiZHZyR3RINWtUMUtkRXRTN1daYWN2WkovMGJa?= =?utf-8?B?VGpFTDZPUHBFYWZoRGlEYUJaYmFBMlBJL3k4cUIvbnZNYnpFc2czSXJSNGJG?= =?utf-8?B?cGFoNTEwQ2I3aDF1T3lUNVJ0ZmU0ZSs2SHlKSko0aFErMHBESHZ6WmE0cWFx?= =?utf-8?B?OVptcjFIYkNYQitITEhuTnpyQjdxbjkycmxBV2FNTEVRUWd0c0UrWXVDdUlY?= =?utf-8?B?VnZTK09Wdjdqdy9US0lMelRXQjRFcGFHZ0ptVDdTcTVMUHJrSHBaODh3ZHhm?= =?utf-8?B?QzBRYTJWb1pXMU9GaUF3cVpnYnVmbjc0aHJEZGxBdktkaGYzTmFEVXBKQXNP?= =?utf-8?B?bVUrTDBSTXBodUMxSHlmQUJKS2h5SmJReFB3NTk3M0VTYjVudTRBOVlTdXE5?= =?utf-8?B?S1Z6cU0ybUZmb2N0SGZLQ2FzRG9tUUgxL0swRUxWUHIyRXphNTdnRVhjTFI1?= =?utf-8?B?bGRnaTlEQ3NYWkd0UkxsVytqQmVnSjJabUU1SktIMTZLT21xaXVIQXdoUFU5?= =?utf-8?B?UHB1WjhCb3FEeVJoY2VxZDFBaVpTR3UydDBualo5N2ZzcTNiTldxUkFqekNJ?= =?utf-8?B?akgweFFaWkpTOTVTTDhFdndWNVN5UDhZQ3p1c2huNDNza3l6UTZWUjVGaWJ3?= =?utf-8?B?d04zbDN4aTRnK0xZNHlQWkNLcG1NTHNCSUh5eXpMMjI0NHh0ajRLVGliVmFM?= =?utf-8?B?L2M4OUNpcTNDT0FnM1ZkWndQSEo5NHlPVGo2a0VnMFlyOTZzLzBOaENYS2Fo?= =?utf-8?B?VU9nMTh0ZW9tUXFnOWRKdW9PSVova3lRZEY0OGZib3RKclU2TW9laC94K2ti?= =?utf-8?B?Q2xVVWg0YkwrdmJpNm5SdVQxV0lRVzZ0U1BtU2I4VytTbnVaK2VRRVllcFZG?= =?utf-8?B?a1dGOEVMUm8rWjc4YStOd0UzZ3QvMWk4TmRwc3diUEdRcXpLaTBIZlZjUG90?= =?utf-8?B?aDNjZncxK3FBOUI5czBZbVR1emZrMmQ0a2lEdXp6SjBkS0prek10Q1pEQlQ5?= =?utf-8?B?SjJIeCszT2RYWVozVStteDJWMnk2NW4vZ1F2S2hhOHM2ZFUySFM0eS9wR1BE?= =?utf-8?B?d0hkS00rbHJ4SDU0ZXV3UVNpbDE2czVNTTRjdndhNm1xSGJoQXZmbGVOb1hy?= =?utf-8?B?OXkyR0ZEK1RiZlo3TDJaRXRjODBmcENmb0tLM2lES2NMcDRiZy9mUjlPbXlz?= =?utf-8?B?TnNBa0xuZG1nVW1EZkZwZllzZHlKYUs3UVEwRXN0ZGxHaStQdzZhdVdvZ244?= =?utf-8?B?NlJTQ2g2ZXhqNUZidmVYSThtMHk2YmVsT3ZMcCtxVHRBNVh0b1c4YWErRFlG?= =?utf-8?B?M1BQUW1zTFVhMHJzZlgyOFltbU45bzZKYSttamNJWFVTam94eTd1T2ZHY0pr?= =?utf-8?B?aTQ4ODMzaGN3T3FJS0c0Y0taY255SThTUVZYRHBJZDRIL0kyd1FWT0JEV0pD?= =?utf-8?B?UEo0UkExNmRRckNyQjE0a1NHWmZndHc2TGpJM0R5VFNRTHBWQlRYTytCSmEv?= =?utf-8?B?bkE9PQ==?= Content-Type: multipart/related; boundary="_004_2BEE52EF85954DA7AAC2096354CBE2EAglbcorecom_"; type="multipart/alternative" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: LV3PR12MB9332.namprd12.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 821e462c-061c-47fe-f606-08dcc8f4aeb9 X-MS-Exchange-CrossTenant-originalarrivaltime: 30 Aug 2024 13:07:20.8675 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 791b26cb-3fdf-47c3-b85d-bd9f037e3e7f X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: gmyHFlOpnbmpuooulMgqGD7DdPxV2lvpF5ewZ5R7IUCmfSuftla/uw/+or/N3fBpkZp+tL15XjCUDLTGZYSsWA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: LV3PR12MB9439 X-ProofPoint-Routing: 000e5c18 X-CFilter-Loop: Reflected X-Proofpoint-ORIG-GUID: eY2Ytj42xUCzypBXVlWpo8H2dTkc-7se X-Proofpoint-GUID: eY2Ytj42xUCzypBXVlWpo8H2dTkc-7se X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1039,Hydra:6.0.680,FMLib:17.12.28.16 definitions=2024-08-30_08,2024-08-30_01,2024-05-17_01 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 bulkscore=0 mlxlogscore=999 suspectscore=0 lowpriorityscore=0 phishscore=0 malwarescore=0 adultscore=0 clxscore=1011 mlxscore=0 spamscore=0 priorityscore=1501 impostorscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.19.0-2407110000 definitions=main-2408300100 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_004_2BEE52EF85954DA7AAC2096354CBE2EAglbcorecom_ Content-Type: multipart/alternative; boundary="_000_2BEE52EF85954DA7AAC2096354CBE2EAglbcorecom_" --_000_2BEE52EF85954DA7AAC2096354CBE2EAglbcorecom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable The replica, or leader will async to the DR. The DR is not allowed to beco= me the leader without human intervention usually. It just sits there for a= rainy day. -- [MDLIVE] Matt Wetmore Data Engineer m. +1-415-416-9738 From: Rajesh Kumar Date: Friday, August 30, 2024 at 4:50=E2=80=AFAM To: Pgsql-admin Subject: DR set up. Hi all, We have postgres 15.=E2=80=8A6 with one master and one replica, pg= backrest, pgbouncer and patroni in a openshift environment. They are planni= ng to migrate cluster to ibm spectrum fusion HCI and also planning to imple= ment passive DR by stretching Hi all, We have postgres 15.6 with one master and one replica, pgbackrest, pgbounce= r and patroni in a openshift environment. They are planning to migrate cluster to ibm spectrum fusion HCI and also pl= anning to implement passive DR by stretching a cluster to DR using Metro-DR. How DR is possible in this case? Any assistance would be appreciated --_000_2BEE52EF85954DA7AAC2096354CBE2EAglbcorecom_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-ID: <8BCC000F8C98DB4E90C43F6D7A7F8F96@namprd12.prod.outlook.com>

The replica, or lea= der will async to the DR.  The DR is not allowed to become the leader = without human intervention usually.  It just sits there for a rainy da= y.

 

-- 


3D"MDLIVE"

Matt Wetmore

Data Engineer

m. +1-415-416-9738

 

 

From: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Date: Friday, August 30, 2024 at 4:50=E2=80=AFAM
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: DR set up.

 

Hi all,  We have postgres 15.=E2=80=8A6 with one master and one replica, pgbackrest, pgbouncer and patroni in a op= enshift environment. They are planning to migrate cluster to ibm spectrum f= usion HCI and also planning to implement passive DR by stretching

 

Hi all, 

 

We have postgres 15.6 with one master and one replic= a, pgbackrest, pgbouncer and patroni in a openshift environment.=

 

They are planning to migrate cluster to ibm spectrum= fusion HCI and also planning to implement passive DR by stretching a clust= er to DR using Metro-DR.

 

How DR is possible in this case? Any assistance woul= d be appreciated 

--_000_2BEE52EF85954DA7AAC2096354CBE2EAglbcorecom_-- --_004_2BEE52EF85954DA7AAC2096354CBE2EAglbcorecom_ Content-Type: image/png; name="image001.png" Content-Description: image001.png Content-Disposition: inline; filename="image001.png"; size=3811; creation-date="Fri, 30 Aug 2024 13:07:20 GMT"; modification-date="Fri, 30 Aug 2024 13:07:20 GMT" Content-ID: Content-Transfer-Encoding: base64 iVBORw0KGgoAAAANSUhEUgAAASwAAABeCAMAAACuPtk5AAABg1BMVEUAAADxZyPxZyN2eHvxZyPx ZyMjHyDxZyPxZyPxZyN2eHt2eHt2eHsjHyAjHyAjHyAjHyDxZyN2eHt2eHvxZyPxZyN2eHsjHyAj HyAjHyAjHyAjHyB2eHvxZyMjHyDxZyMjHyAjHyAjHyAjHyAjHyAjHyAjHyAjHyAjHyAjHyDxZyPx ZyMjHyAjHyDxZyMjHyAjHyAjHyDxZyMjHyAjHyB2eHsjHyAjHyAjHyAjHyAjHyB2eHsjHyB2eHsj HyAjHyAjHyAjHyB2eHsoJSZ2eHsjHyAjHyB2eHsjHyDxZyMjHyAjHyDxZyPxZyN2eHsjHyAjHyB2 eHvxZyN2eHvxZyMjHyB2eHt2eHvxZyN2eHt2eHvxZyPxZyN2eHvxZyPxZyPxZyN2eHt2eHvxZyPx ZyPxZyN2eHt2eHt2eHt2eHvxZyN2eHvxZyN2eHvxZyMjHyDxZyN2eHvxZyPxZyN2eHt2eHvxZyN2 eHt2eHvxZyN2eHvxZyN2eHvxZyPxZyN2eHsjHyCPc5fhAAAAfnRSTlMA+z/xCAz+XMLJ+Sau+Mn8 6+rJ4vjdSu/l9IqwP+wl/diPk4LV4qmXcUt0Ojofc0Y0uRQuDOnc0KFaFvS1sZ0Re3VTBtzEaNG/ UlKblr6KbWFazrtFQB8M89dEIHYq5dO0qaCQhikWwoBrajDal3pWS7WonnhiMyM6ZDdtHG6V4Br4 AAABAWlUWHRYTUw6Y29tLmFkb2JlLnhtcAAAAAAAPD94cGFja2V0IGJlZ2luPSLvu78iPz48cjpS REYgeG1sbnM6cj0iaHR0cDovL3d3dy53My5vcmcvMTk5OS8wMi8yMi1yZGYtc3ludGF4LW5zIyI+ PHI6RGVzY3JpcHRpb24geG1sbnM6eD0iaHR0cDovL25zLmFkb2JlLmNvbS94YXAvMS4wLyI+PHg6 Q3JlYXRlRGF0ZT4yMDIxLTA0LTEzVDE1OjU3OjA0LTAwOjAwPC94OkNyZWF0ZURhdGU+PC9yOkRl c2NyaXB0aW9uPjwvcjpSREY+PD94cGFja2V0IGVuZD0iciI/PrF9NdgAAAuCSURBVHja1NpLbxJR GMbxB6ZN29FNAVmVsLeJC5JZTbpBEkJCSSiktMXa+/0Sq7Zq1fN+dZWpzDDPDAeYM6n+d1qt6S/H l3cuuNpZ8dr5Ak27O09/8utbjNRb8b7it/N4Cl2r3ezvun1MWqWbHTSPQf3GanZQ9wSa5la9v7ra eMCwk252fN0KvO5d17IPAVgyzLpAfJs5W4a9QLCORGU7udYV4pvPqEHl6xNM0txiWXktYFBWDStd Ylz7GfW3Izy1UFLaXmNQS7YfT1uSB1wJ1EFcFxJsF349V+JzOyuIqTL8CcoN6KsU1N++weu98ltE bP2CGpaZh1dTTdAt/nQlN+28c7EpL2FJsANEV5Sn+GTVZHzOxZiT5VWAvldq2AK8jlWgj4hri03x QU3SO/ypbsPqfJHdNTuEJTGDy4nFqoo2t63BUk3oWlCMhYLyK/dB8RnqwmtvCiy3Dse5s9CWMFYd UbUkFutQJqjWG491DV37UVjrKtCnCQ7We2bWY1k1OK6bx2fCkirA2fFYazJR7bFYJehaisLKqkDL +iOpjuE1X54CqyNwDiCnOZuw8uBeCmHR13TdjMNahq5FxvIGmV9Xq5zBU3OZKbAg2zcXaNXlM2HJ Oe9XYgBL7lLAulWB1gFurkDjfWqsorit87qsgbFchKsbwZKXRrF49hQA7pjO3vRYOM1ZrtMGGEsO MVpbzGBJyzzWvgp0Ce4VjfcpsG4RyhLqB60NE2LlDteeOujUbKGKxrEeVKA9UCfl0HhnrK2F728i e3fb12DxHn8uk2AxBoo5CWWZxOKTk6kg3EdF27uPpf+3GYtbQSB7ViygF+a6M471TgU6QriS8ltC JFYpIVYNtEfNhMXzbtc0FgqRQynqqqZhBIu7p7VhRix8sSVYziQWj/gHjLauCMUcFg+X7YRYOLXp aCXGohHOV9N87JqGsfhTviqJsPhbHJjGwrWK/cFf0/RPBcuGl5MMi6eeZRzrO82lSMclmMXiz62W GMCCS5+0CbH096v4f2jDMBbf2LKNYB3SBbVRrI9xlzyfFJGY27OcTujG1l3w1/WZsTYlUN0kFh+g W1qyaLzTBv/zdVTH2bFY1shJqo6uDb3ZsZCnoWUIi297XvOS5W3vhKVtcSyWPXJpk0eQ5wz52bEO xM82j3VJd5dpyVrC9FjrGiw4QR/xs3szYvHl5aZJLB7xnyKXrEYaWMXYuyszYvFFz6NJLB7xy1Hn rYQ0sJCTqBwkwlqRQFXzWP3giM+CJ1kzHayeLRHtzIzFS3zbKBbD7PvPcGl7N4yFG+HOMDMWP87+ mgLWN+W3hUFHPN7NY8GJvvYxNuB3zWHxiPef7i/TeE8Dqx19VW1qdZCeWSxe1jcAIEvj3fieBYBn fA1JsWr08Mg0VqUcWkD3abyncrJwStM9KZYtftupYGEj9GBii8Z77OVOfzUb1Ye+FotfX+ggKdZn enpoHmth9O7yJY130xfSNvj3xEZirDytWUax+Kr5BBs83s3comGXe/E7T4zVpufdaWA1ld8RCCM1 rOCMzyMxlkUrm1ksHvF7lzTeU8R6QSvk7FhnEqxoHotflykXaLynh+XP+DUkxVqjF5pSwmqoyJaQ Olav6tVLinVGDyTTwsKyiqqRGhaXDOurJSNtI0WspopoGf8JVpGe0F6lguV/Q675z2LdY3PQj82r aivn8quSse+UVh5WqWxfg8UjnspU/lksTXUQ1tjK7z9MhdXQjHfC8irEpfafD8sBYWk71mDpRnxj DJa+jWfDssBY+rLTYB2pUCUkwlp6LiwHM2HtTYHFBs3/E+sX+3bQgiAMhnH8lRZkR62z32HQsVsQ QZdmEHqwzCjCiCDp8weyKBounTAwnt9ZEf7M9yC+HpnFGtWLpV4lv2x18TUsyDBWwJvEun2fjA6e rOhIprEcpo2lH/GLlrHu9mP5MZGtWJk63s1jOdxyrOEpJ7ISS62wbBkrU/80M4mV19sKm4QrqsSD JjNLaDcp3gbKeDd9dnAgRRp5UjQlnbQ3k/z5xww6l/crwn0Rb0iHiWT8UyIYla4XVxLiQdXWwYtu E5jttq6WcDNO/4/1mUQAAAAAAAAAAADwbMdcdhSFgjBcq7PjspNLQkRANMEg0Yga4iVGY3Shm36O eYX/0cdThc3M2M70hJnEZOZbNCJ46tR36hSk//N7TNf0QuzGbyN6WcYWNvQUU1lKwJb+KD569MC6 UAA6F3pRfGBGT3EABUaUtmdpO1NeBvgP1yYWYHQAFPSadAAV/ETWiv4sATASWf2Hay7cMdHOBM70 iizgJj8R4vzxaU+hdk9k+bCkfxZ6/V6QPVYndIi59pfLvT07Tz+urGF1IGbjT/ThYnaLnDSZP6S+ 3SOKUspjO45IWKZlPJe0t3PKytmEvD6wSk9aVkrFrOyxOcG9B9tZOPG27MdlKLPxQsrMbno72cZx f3SPmlf785KEq9ktV5N6QjmtnOT4xp8HxGyrjNph4Y0UJOcZYgs3jODDyrpALVkaEBCNOtCUdKOH xObWZ6ALjSOzU9B4dMPmsYcTMKWWNTM42JJqch6XCdjQChq1kHnGuOEGHEDptFOUfWi2JKXKhDIh 24YmIhoDbPANeKNWbGEQxXWvjQH3ks8VZg+ymI7kXSDmE8PT9x71sgMovJOuDSSn4RG8xU5A8uUU AwOWBTfcrKeDFPCinHNzD3mqeDBmA4MaeFRzeHXEjAGYWWRBHwYGHDYCxMOFAy7DM1Dkiy4wJKIQ UGk+cKFGugbmdKNCQu3owtfG3FqWNWWBCKgmgeUaGnUlmks4Axf92dD3DnjZvPuz0pU7jnBZdClu OyzLkA23vvcsaVAbLldmDpu+xZAku4j5pORwHOALMGFZlWwIh0P7clKxLC63pUKoQ9gyt4hasQQy rvEry5LsdgrXRpbAwSds8QKDkw+bavNgEePKy1OuDQR1+U+VjmFjT8wIai2yzLoPLEjofy/rWhda znYtHOTuVDwutKy6LXCgY8KNLEWXZclvYw5iIdeC9TBtCO+VYMoa9msBUbMNfRprsimfpUQlCp7A MTqf08jVZ56kWSfBVid0QecuPGK5P8ry62AbEnrfy1qhex/09O7UYGfyo14TlVt45q3O2xgx5yWX fB5jD1//MakdCfo0CegCa1fvSY2N3kc9S+awVhhygd8xv5Wlr3FP1YM69yA9PZD3g6yHlTnAom+Y 37NzcWBZjRep5x5m1Mz35EJ4lPUFhuyeVozxzuY7Wd7HL6VTBRqgwyljlR0Oh8FwtNayOt/JWrKs prI8PXb4K1kBMCQhOo9ohfg+6JePZTVLFFGg4KaRtzAfZLHuUQ6D2tGHMqwbhoXZZ2RRidDESuKn JK9CiwdZWmqgV2L0/nbSyAqgpo+yaqvm+yJeaVCnl0FNn8iydvXdGfXqKRQoH2X1cfZRUTs6SIk5 AaMnsuSOZqfUCnxYfOyifJS11rLIlvn1+NE4a2Rh9ETWFbhIVM7Vkit7zOiJLMz5Bh0g5Sj0pj6S NYFSbV+yRFGjrZEVNrLMfKDZbgIpKJ46f7KiZZZABc9kHYD9aOkDUSOLn7X76/hBFnMEjlmwMaDG 3LQwXwclMHwqC/46MIGUXzmd4SRVgDt8kEUOYFM7THSbDenqhIpaVtrIeieUKr/ntrShsXIunlqW 1fQsfowzc9liIQmVzlEHrx5kUQXGyEiCMVtqZLnYyiHknpVAs5cMNEakYN0n1MiKWGgrwn1ONUHV 39Fl/0U223xMNZuqMoWSNUyK+ZpqBrHtrKbcNeaHesRixNUTefL90XH2Uv6LZsxBdTwRHcyT5LHP qGFcJU68oZqh6ThFQJpUjpsjD+MdM23EIc92u1dicjNJ/CkNkoLo7RjJd/2FHIEX/pfi34cr6/NP si7923xaluzef5vPypLX3X8cDw59BnmYtOMrQZDU1/S1k58AAAAASUVORK5CYIIAAA== --_004_2BEE52EF85954DA7AAC2096354CBE2EAglbcorecom_--