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 1t0kuG-00D283-1x for pgsql-admin@arkaria.postgresql.org; Tue, 15 Oct 2024 17:00:24 +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 1t0kuD-008xBa-Fa for pgsql-admin@arkaria.postgresql.org; Tue, 15 Oct 2024 17:00:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0kuC-008xBQ-SY for pgsql-admin@lists.postgresql.org; Tue, 15 Oct 2024 17:00:21 +0000 Received: from mail-dm6nam11olkn20810.outbound.protection.outlook.com ([2a01:111:f403:2c15::810] helo=NAM11-DM6-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t0kuA-0012EK-DK for pgsql-admin@lists.postgresql.org; Tue, 15 Oct 2024 17:00:19 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=tbtIntI0QNUrRnqFUrxOED7AGv5A6a7FaXdXkE9+iX8P3PDVAFsi1t+0j4Ck5604wCP4dgPyNrRRzUKDPKTe/X+jX9IJV55Sy6BWTUzxPaxZXlMGoqrLiLp8XySB+aOxgNpBLPGSdrxAIbBmgZmLGA/IscYzI2xxl2YzTTnJsXvWTzW1SgnU1mwZ+S1fVlHRgcVfZHMfZQ3bfJrzgpwZIDPMvIf9Sj0Gz1oM0OqPs0opvPnf4vRSl8JN2LAkeunhKxZaqk/fkMMJSQA8+4vi2DVspVJhooK/Sjbb7VlSCiqlTFs1kzUmokanPX/xv5XAxo5My/mLkXu9K4uHFWrNJA== 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=vAPTuOCw1FXM9Rm+PvLGX7oG7ZCn3m24FkSJZS+GiU0=; b=BwY7QN7c5rPfMbPe/vLOSJqbKsO9EuVT94FwqOW9fcBVsfG5/MCG0MRELYfrTDUjXvGPT1ESscNpcGmpbacc7evb4JLyyU9RXAqwF6IwtJi0KTOFLWC6ifuxrO6f7g/gB4n2EJ+07t+iADeDj+UauInJHtIp/VbdUhwITq7Xruq+wfGCwWNXc0gIgvv1SradsrlihlPznkYoqLkcnEU0Wh92BMQWU/ZiHdTF2b/YYQeOBZqCjmIfjYr5h3+1gUQF6BH+S/vLZDAPMjzNTn/VCiXVw/HLur9mUVy0ixg8MBfG+Qa7q/hKjD9/EEP9kAFrNHGhnSk5eCZfEpqh4gYBuA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=vAPTuOCw1FXM9Rm+PvLGX7oG7ZCn3m24FkSJZS+GiU0=; b=GS8fjghOnsYepp/KRQuBhWCy0s/Im28I7dxLiYHs0kFrZmcGo/tHkHCmlpmijRdLLmV/FRZZ4LfLYrvFV+i0g+a/c4RGbX0Q1AsgVVMlNnGrFwAbKcS0hUQXDeKnw/XI097KtNTe8t3xPQmqP3T60UFeClEP/qoqbCBU+HmECTBDkHNYcMpIXkTWxriiXF6thQDy9s+DIgk4QCzNOGkutn54NXRewWSCata9NjmJH5ndqwC5kWjLBd4qHAMW+fb3MFBhDAEdD8YIXberhIekdR3YtPTDUw4f8ATb8mR2TzJhB3yUc3eyBb91hbrL7xEV5R3YZIt/BZzie+UIcYEd5g== Received: from MN0PR20MB4912.namprd20.prod.outlook.com (2603:10b6:208:3c0::13) by DM6PR20MB3297.namprd20.prod.outlook.com (2603:10b6:5:28f::23) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8069.18; Tue, 15 Oct 2024 17:00:15 +0000 Received: from MN0PR20MB4912.namprd20.prod.outlook.com ([fe80::2b55:f111:9de9:3cd9]) by MN0PR20MB4912.namprd20.prod.outlook.com ([fe80::2b55:f111:9de9:3cd9%4]) with mapi id 15.20.8069.009; Tue, 15 Oct 2024 17:00:15 +0000 From: vignesh kumar To: Rajesh Kumar CC: Pgsql-admin Subject: Re: Postgres DR using ACM Thread-Topic: Postgres DR using ACM Thread-Index: AQHbHsHbAnzdNi5ZIU6o2GuoRgyOa7KH+KGBgAAQKoCAAAB2Qg== Date: Tue, 15 Oct 2024 17:00:14 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-reactions: allow x-ms-exchange-messagesentrepresentingtype: 1 x-ms-publictraffictype: Email x-ms-traffictypediagnostic: MN0PR20MB4912:EE_|DM6PR20MB3297:EE_ x-ms-office365-filtering-correlation-id: d8adbbf5-ea42-4191-b4cc-08dced3ad6e5 x-microsoft-antispam: BCL:0;ARA:14566002|8060799006|19110799003|14030799003|7092599003|9400799024|15080799006|12050799009|8062599003|461199028|1602099012|3412199025|4302099013|440099028|102099032|10035399004; x-microsoft-antispam-message-info: =?us-ascii?Q?rBLxZ5HYyjwntDOID6PfOnvaqrMJJsyOxv6oa3pbpQ4YPK74mr+8+0/eYKd9?= =?us-ascii?Q?2YE4sjH3BGNsDFzP166bYP5ULiUEd2E8mQTigE1S/TpONvT7V4qngSvqtETH?= =?us-ascii?Q?qd/uyoSTzbHNkUHhVj1vK8eTMsr45UpiCaqFySGEavtD4eOOXAF/CUDup7hB?= =?us-ascii?Q?CgGWT6xzu7PyeasI0Ge707uK/KN5ncbiCGXr3v9SBM54Q3/JnfVnMdvdYx8N?= =?us-ascii?Q?GqhoXfmoJaHMzlwc4wLMsFkx0Ti82tH7NBWIVFOPdTRMGjD72oitSigvgxxM?= =?us-ascii?Q?mRSNvC5jy7Bek/gw2UcXoib6mQzOeFHX+bP+t9c6XbvRd9l53lLkZRsFtm9q?= =?us-ascii?Q?XPj7p7MNg6agweW3WMJ8YqlGgdFr4ZyoKINmDa0NYR2eTGlN2oYTLLNGPCZ3?= =?us-ascii?Q?V+2k/uPqpPhDEkOwrGbugqIsuaHmsRqPd++7C8/uzi/ZaeUFvnuGpiRivVET?= =?us-ascii?Q?UwbLX5vfALpRXaG43QhQEzmk0cDD7h7xIOWJfxXMzn/rlbXq6s5tRSUfqb8N?= =?us-ascii?Q?N9RhuQswpL419z9GzcWJD3IJjssMMIydTqpsxwMtJ4Q9MQ+SRSxr4ln0xXh5?= =?us-ascii?Q?rtzNpaByoF7ajHE80JMP0EuacOAqnlMq+X7ONE7POf5tFJWqSJ0U3AdezQdc?= =?us-ascii?Q?3DObLz0W64whXZGGWPq+Q/fpVgpzJaA45UU9w/GSYi6+6TMB8DOV1GLlDfdP?= =?us-ascii?Q?l74vUaPfL+i407JVsAp/Siqf5SSSFrDVTD+JRPuoOlHhxoXChw1eEkl/OxXy?= =?us-ascii?Q?w9BMPEf94/HGaKLfLa/2LojPqZ3ufi1Kc2rGhdmfJLnMHhec/hAWjeKIF2oG?= =?us-ascii?Q?Te8PzWkZZgVNQeOTeAbKbAKmyTzp49IUmkxyFRwc3Ik5ADhKwtlAheqBd4w2?= =?us-ascii?Q?mz6NKQEUBZeJiY5I13U+c+T8M8vr/GdrcMHHv0tP1P84qvbswtCJPTRNFeOD?= =?us-ascii?Q?GGqQyFu9e76KURBjgMtIqw=3D=3D?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?ap5fZ4g9e8+A+T0fR35KGu5vKo2TQ06+BRmic+6DsN/JHdzKAaGiEMbTsk66?= =?us-ascii?Q?GV98aAfhxGkCYWEp1C2hkxj5rlXI9X3mFfhud9tUVlqa71VR5ohXK+YMVqlw?= =?us-ascii?Q?SjK3+2hoGIyRvo2hi8ihYO+HjVX0uc5m2w1FK3YsC59e40wJMeAmJHIlDuY1?= =?us-ascii?Q?AzXp3O7W3/vFGjTx488H14+O9bn1CBLhAJJTeS9r2sj9vS4N9df0aurILuQI?= =?us-ascii?Q?CT+2xtSv1WAqKSbf4VF2jzRuEujxnsZqj4qVNkGUSCCNReuQuOs+lnl0kwL/?= =?us-ascii?Q?1QYLRI1Z79kJtnmiiIZlYACP+N1d/1mSldjfIsWGDmxQmVbRWzO9YHshEwRF?= =?us-ascii?Q?wUVvi2zqTzhd+4MSyn34H6tgFDZqTgJezrplUQWZSWMAU5aMOVLFF9LGjUgh?= =?us-ascii?Q?M5syeqQomHC0TecvkBCXuVjslaH2FYwPbG092r2y7ihkCoY3j3FlB52yZA1O?= =?us-ascii?Q?cJ81CH23h3hIT+WmMu4gi2d6jyr0dasfrZm5bgfXL7iNPl4+UbjKv3ObSG+D?= =?us-ascii?Q?BelwSb9SWodS09HZ5it9P+O1o54D5qo9WqqzPxhu2MPzTNPO10+CSIbv6PQA?= =?us-ascii?Q?UOaunvgbwHeY505gDEp74h8S90M5xhfGWm9T9hWHL8tZnNYEgaVv83fxqU9Y?= =?us-ascii?Q?RAnMds2gWQgIYCiq57YisWGVvP9KweLrAjQmKONX8fO1ltwh/Ihbd7w9YmCH?= =?us-ascii?Q?knOTAJJBBZypJwNqgF9iAymKjSVMtG6RaBCULWf+JfUgZEvvFAELoqTvVU0D?= =?us-ascii?Q?6vj/Pvr83WXXl/KExwYYB1j7bB/2Cc2EFOk51Y0gpZDroxrtJeOwLWBNEgeh?= =?us-ascii?Q?GO/Rn4QzK22DSQWy+M6vuxp+GxzrxFavxBnWaWVl3n35Jxz8Tbwz52rFXauA?= =?us-ascii?Q?BGMIo4LWndPd7no7mrsjgM/+/O1FCZVkCCPexG+7EM3JC6ViqXNBDye0FVqy?= =?us-ascii?Q?Ye2XbSfDINzA9Vlz/ETH77vexzz0v6nRgI3jF3Weyuzkouc3JavW+nR+px4S?= =?us-ascii?Q?RGpRl0RrmnJ7eti+9KBiyHBZUjVIkJ6KqS1zI436X9QHM9UI6uX/pxfUGe1D?= =?us-ascii?Q?+QLZfntP1X/hVFwJTBQj7J4INivDPrbG6tiUA4KxtHFhB5oABXL4RnEaVZbj?= =?us-ascii?Q?0wpn6IK4Ycdywgxauc424Pz9NPtnb0h+tDPOkCFQ3bJ81Dlj50f5btBmdcJL?= =?us-ascii?Q?mixjbWtzoZvvTGPubrLHk2F/t2Ux79gvsrfVc3zQcjHLVA1jfyghWO7E4IHs?= =?us-ascii?Q?9expCh0hM/lFwqA7cs7dg2R8gs5NRpwwQjSVsOSKPFRUs/W0EouBG055Q2pj?= =?us-ascii?Q?CPE=3D?= Content-Type: multipart/alternative; boundary="_000_MN0PR20MB4912EE54A2B8E5ADAB6DAE7287452MN0PR20MB4912namp_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: MN0PR20MB4912.namprd20.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: d8adbbf5-ea42-4191-b4cc-08dced3ad6e5 X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Oct 2024 17:00:14.8823 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM6PR20MB3297 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_MN0PR20MB4912EE54A2B8E5ADAB6DAE7287452MN0PR20MB4912namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I'm not getting the term crash here.. so you gonna perform some transaction= then you wanted to simulate a failover.. just kill the pid of postgres.. t= hat's the worst crash that could be simulated. Depends on how your postgres is going to send the SIGKILL or SIGTERM signal= to counterpart Sent from Outlook for Android ________________________________ From: Rajesh Kumar Sent: Tuesday, October 15, 2024 10:26:19 PM To: vignesh kumar Cc: Pgsql-admin Subject: Re: Postgres DR using ACM Perform some transactions , while doing that crash the primary to see if it= fails over automatically as per Dr policy On Tue, 15 Oct 2024, 21:28 vignesh kumar, > wrote: What's crash test btw.. I mean what in specific ? Sent from Outlook for Android ________________________________ From: Rajesh Kumar > Sent: Tuesday, October 15, 2024 10:49:16 AM To: Pgsql-admin > Subject: Postgres DR using ACM Hi all, We are running postgres 15.6 in openshift env. We are performing DR using R= HACM. I have been asked to perform crash test. Anybody guide me with some kind of info would help. --_000_MN0PR20MB4912EE54A2B8E5ADAB6DAE7287452MN0PR20MB4912namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
I'm not getting the term crash here.. so you gonna perfor= m some transaction then you wanted to simulate a failover.. just kill the p= id of postgres.. that's the worst crash that could be simulated.

Depends on how your postgres is going to send the SIGKILL= or SIGTERM signal to counterpart 

From: Rajesh Kumar <raje= shkumar.dba09@gmail.com>
Sent: Tuesday, October 15, 2024 10:26:19 PM
To: vignesh kumar <vigneshkumar.venugopal@outlook.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Postgres DR using ACM
 

Perform some transactions , while doing that crash the prima= ry to see if it fails over automatically as per Dr policy


On Tue, 15 Oct 2024, 21:28 vignesh = kumar, <vigneshkum= ar.venugopal@outlook.com> wrote:
--_000_MN0PR20MB4912EE54A2B8E5ADAB6DAE7287452MN0PR20MB4912namp_--