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 1uviWn-000KS9-S9 for pgsql-general@arkaria.postgresql.org; Mon, 08 Sep 2025 20:31:55 +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 1uviWm-007a46-34 for pgsql-general@arkaria.postgresql.org; Mon, 08 Sep 2025 20:31:52 +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 1uviWl-007a2s-HI for pgsql-general@lists.postgresql.org; Mon, 08 Sep 2025 20:31:52 +0000 Received: from mail-westeuropeazon11021111.outbound.protection.outlook.com ([52.101.70.111] helo=AS8PR04CU009.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uviWj-001Dcw-2Z for pgsql-general@lists.postgresql.org; Mon, 08 Sep 2025 20:31:50 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=LkhNG40V6/Ww2S/pN/OEFFUi0OB1vvU3lfZsIoA16vwf823cAir6sw6TtC72+QMSu15uCAj9alL2Nc13Nqad7/zdYandV7XgZroeqQCsSXJGHH5f+sOTEjsniSbAUHlsQ17++j4auWdxRO8wAIkGdgf/qW42gNlZ9l72zMhOS4uIxD7Gya2ugSh725Z7NMdBmioa0e2KZE8KWo1iYnUxe1yvqMlu0bbSZoFxNMm7OLDd7Zng+cZiUxvW8Nb7thZddc7jtNEveT0JSE5dIeKPabJgDTBSA7dnw0KUYXGFpfMgF0RiYqxycD2H0b4yFg1wsbljgCJ4/9pTPhAkOYgs8g== 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=5VvKnVYg0QXNhnJzD9Vy3FHSCkVd54ccuR2vsixeZfo=; b=ITqbr4LWTM6glrSGZjznD8P7mJqI+SrxleYpb5eRtc3mgoe0U2AEveNfvrkQ3BcKYWJ+gw5IGu45gudbJ/y7fyKRTvwiK7+ojOHvOnQwwjIycLNRUW+qMED9bSLALYi1V6BqS0kdyzesY5Vvqj0eW0dmkZ6zkOcyPVI4nKx7QwMkxt3ucZSQgFJ3DAplpAhLk7d5vSZy6e2Q/2WHMntAEP7Hoox8OfEsuyXH+wbdfdLlwBV/VGqjDvysrBHkg61r9rqF0iBnsWSDeO7V6hKYRtUfEtbAISzQ5Pg/Aa2c23IE0XrEJag8/pku307kI2ilNGf8EBJeLsSeIWVfOy4kJA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=nic.at; dmarc=pass action=none header.from=nic.at; dkim=pass header.d=nic.at; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=nic.at; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=5VvKnVYg0QXNhnJzD9Vy3FHSCkVd54ccuR2vsixeZfo=; b=uxrimXuyXEmTRC3C623fTjJJhoPjZcp4wX9JnsprkbcRTYjeubB2ivD17BIW+39NuEAvvpPH8X8Jv9x3nXNlo0JoZxt4Ajhl9mn40xxXYxlqiUqFQJrSLAq0FxF4UKDmFKqH+HLp6iDg9QjqpJIvMRnvjfN0uZ6OMZlgL3zDfqxLFNROmOUB8WxXtR/9QS1oOUcVgrIGpzSwBXjVaNyaHXfkUZGWM7brBjy+p5oC1nbCqySv1N0KZlgeUVwdxeOvpYuTJSVQnYbCRAN715UQlutu0Ss1oC+ZJUm8kg6cAlQu7RwqqvVDK1giBKu5/Cg8f2fV4XXOLDPnSJvns9UG5w== Received: from DBAPR03MB6358.eurprd03.prod.outlook.com (2603:10a6:10:192::20) by PA3PR03MB10961.eurprd03.prod.outlook.com (2603:10a6:102:4ab::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9094.22; Mon, 8 Sep 2025 20:31:46 +0000 Received: from DBAPR03MB6358.eurprd03.prod.outlook.com ([fe80::6cf7:babb:d18f:f1a9]) by DBAPR03MB6358.eurprd03.prod.outlook.com ([fe80::6cf7:babb:d18f:f1a9%7]) with mapi id 15.20.9094.021; Mon, 8 Sep 2025 20:31:46 +0000 From: Klaus Darilion To: "pgsql-general@lists.postgresql.org" Subject: RE: Fast switchover Thread-Topic: Fast switchover Thread-Index: AQHcINFrApJU6FDeoE+9lZlKhEILLrSJsxEAgAAJBpA= Date: Mon, 8 Sep 2025 20:31:45 +0000 Message-ID: References: In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=nic.at; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DBAPR03MB6358:EE_|PA3PR03MB10961:EE_ x-ms-office365-filtering-correlation-id: 95ea2902-8fd3-45bd-19fa-08ddef16badf x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|1800799024|376014|366016|38070700018; x-microsoft-antispam-message-info: =?us-ascii?Q?mRBjiKFBnVX9jTQm6CiSg+K47xJgFp6TfJDtGTKMreLwqX7o88D4tWWINx4U?= =?us-ascii?Q?J5i87lryA8Tf8iJK2LydtxCTYdVuBIV7jtaAGZOeDVeSWHL/Koh1f7y93m+W?= =?us-ascii?Q?8J627ocW+uVGmCezO3xdGyS5DVIjUfWeKnBOI5jmSPz4CEQ+nno/+9xfC7vQ?= =?us-ascii?Q?oyjQ2tVtcPGxJNCsGqZOQfOFOoM7ZxUnQCIrgPKfJvaDfc55UeokBPDaePnS?= =?us-ascii?Q?BtJwgNbaNG0u+HRHpQHo+pZZFwz3E0yTJM+QttHEKSvbq88XoRGl3WVqxfPd?= =?us-ascii?Q?+nIKLS89OgJwKxa2+k0/oEu7tt+WluaLCdsXTJgf8OTstKZoMCoxTpReChbU?= =?us-ascii?Q?zmk25v0JUQtMuOrHpk9nGIRDBs4dkLyRaMwEy8DljGoUqqtGZm++qWm6INzv?= =?us-ascii?Q?Y4xaGJJPBQTP3OOPWahz9VMpUdirHJHYPTEoJANPBUyUeQVhOxtTWzHF69o4?= =?us-ascii?Q?EQ8cRROZIU3TQw3uO8KZ3GLeFQ72pL+YfAy/unYQFY2ZYRAIIyX76HJljKOg?= =?us-ascii?Q?kpV5m8Fph34leSNFlnqgBb7/8ZRpTBmthhUc9CWdgdzAbasdQ6vmSPnWBWZo?= =?us-ascii?Q?NPyo9iM3yfgMtfkLr2pmcv2IU9ztalBnndtKfmP/gh2ENuUerhvTTDWgUUuZ?= =?us-ascii?Q?A6E7jcqEtA80+AhNzwCD5CMXloO2uBTRhafkMEDaj9yfqoE1WIj+OyHS00f5?= =?us-ascii?Q?0ccTVhshs6ZrLbMC9jm4M/mIyXsBOuj3A/UtlekzXRSEOKFA6nqeXI87MeO9?= =?us-ascii?Q?l16E+V5fw1VbLQvgKUiu+dGplCP4aozJaBbLePpw5Uol/Di2oczoR5lyS6Xb?= =?us-ascii?Q?Y+FSKq25JOm/5zXIB81+o3U+KMAvcmYPpk4CoJferuXXuNq5zcHrtPyyTvdO?= =?us-ascii?Q?bAe+4IJA1ey+b3FV8kSbdoL/yHqCvh0odQINwDfHu+g/Cb8pqCbGglsJ4Dsl?= =?us-ascii?Q?ermRTdUeRfEVixk6kvxBEenbpSugsOfjMgziX390Fif3Evq3BBe7S4gS1eel?= =?us-ascii?Q?tZOhz0WTrHR3FgtESzysBgIpU3qpGBqBSoANho5icosT2wdAsNCLGXttDEaH?= =?us-ascii?Q?bejeWAflWo7XkS4i92MamHPDQJMocY2RibV5a8e2HUukopbS2PZZTl4j5gXf?= =?us-ascii?Q?2ZABIa0LO5I2Kxyy2J2NW9J85pqmoy2aET3euV+EZygCFn2Lf8f2OA0c3f/p?= =?us-ascii?Q?btHViVBbTkb5A+nA4q3b4S+1MflMpnugCKA/qSJtbfBM63eJUT38bvAfzeGJ?= =?us-ascii?Q?XLhb8YEXcON+QvoRVoJKnQtwzE7NV9LmBqdba3YgN5otLeG1X2W3ffe0CJzv?= =?us-ascii?Q?z2ayr3pGqQktLGJ0vZX1wa2fBcuwr/4R1pXDNAxXEPS0IhXOygQHftHpTpRi?= =?us-ascii?Q?r7Uzgr4M2c/2uD34OKgsvFI/F7Xq283attRMNdGpr7OxPl4ZP1ABp8tyKMye?= =?us-ascii?Q?/xx0cXdgxLK6ZXOauUF8O6iMpfY6NUVfVEkfu9miDuvgL4d15D3vZA=3D=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DBAPR03MB6358.eurprd03.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(1800799024)(376014)(366016)(38070700018);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?dlbsMzd3b6sMEDKbT9AE98qoKG06Krx32sffRsAnVToF7YvChjtYBq5x7sEO?= =?us-ascii?Q?1+etfP7jO4g0cQADCeRkyDznHQepcZe4KFPku+BiGAL/yT7eSS6z/z+MNOfx?= =?us-ascii?Q?g7Tama0zijCglgD/3qEs0nEHgaCNEs1MBXmbb3T9hXIMjQHdSQjreUQgtVm0?= =?us-ascii?Q?DqCTQPM3vC9Xh52qDadv3lt0EK7S/YOuSnWn06G1ANlFSMO1T7pxCUhD0wey?= =?us-ascii?Q?SG1Q+DeezDSysIpu6gp69ao9hTLTvMC/K9Byfp4PbYFD7n6CDiL0pctG+3xQ?= =?us-ascii?Q?htSzZJR+IP4z2iYh9ogPDfBzdXRUdF5ChutsF+HiJrZLHK7+9zMAuOZlFrXN?= =?us-ascii?Q?f6vPB/eyGaNSkgqY5YPj9ex+HKBG4J0UHcfmIMn46yfiIbj1xEwhroxkP7Vr?= =?us-ascii?Q?7KI2iU5CUQ1cvVnHQdlZ61vzPpEsQwXQm+TAYRyiXQZZp2qS4mSjSW5KkIjS?= =?us-ascii?Q?hwb/zAwMvD/v8lxpWojjMFw+Hpab2hCwXC7uFyWS76BXZ5tggL+NTfea4wKJ?= =?us-ascii?Q?DgjPYXVIFal6sau52Icy9OX9gRad2YYqjTXc3yUzuQ2gY+/Q+lV1rFrkoZXD?= =?us-ascii?Q?CDVfS7nIjihudTUIi8nCSqEiwf+EUUf2qYz/cF3YP89Vcw3yj3BVmiS6vFwm?= =?us-ascii?Q?4dAGhbiqRSZgqpWefjUdt4ejjDfClfvkGon9EKy1q3QP4xK4xeOnfof+hGzV?= =?us-ascii?Q?EFNf6/JonNZc2OG1F5TyA3aFJ3/IQKObtojuhBgE4mj+pHn3UZUKFRta9o0f?= =?us-ascii?Q?2vMzbyVLt1eLqGS6TbrMGx0TyTX2gBmbfC2xbYxJM+gdcyFApVXpbRm8gfWK?= =?us-ascii?Q?gfRmufO/YWqsgUBMP5YCFayhLqpZA2vVnZRGNg3NvUtDgOv4NfX1ATsF1P/z?= =?us-ascii?Q?nLEGZEGC0dv1B0rGUQrCzS6BFOQJd9esNwc7jxdk1D1vAA52DT+XFow+7vKC?= =?us-ascii?Q?kmEVj92Ix2D9Xm/5+wKPnWLf5zdkrijH5n2cMYPwieqIycj++3brxyAfcmba?= =?us-ascii?Q?m8v/bK9KWqvPHJpUbrhBtfls4Bd8YXZqWM7xgI7Aw7cvqnb1ePWYqTL4f7Wn?= =?us-ascii?Q?1p8JuP7SAWxmdQCed6DamWB+H1QnjpQ8C9QUvtZsa7zyqbY1q2GRkWqMjfjr?= =?us-ascii?Q?ocRCSip0CCNaplYUCKV1SW6S3EfMoYaki6wbCSjJEKyWliGwgZ65VNf3cvVe?= =?us-ascii?Q?o8/75e2bPckt3fZgxU+dgwv4JPxUqwJH27vFMegp+knkwA0cn52YtpiQjqlc?= =?us-ascii?Q?ASre/1WW7DSs8xFi5sJhLJ/3aJwlOZdoGt/trTem21JWHxuab28cuYWNJ9Ac?= =?us-ascii?Q?CbVKKNkKlfGcTfAkiWYMqUEOyhOPdy/LKkC/NS1pwXaVC1xPjUIRkR9gnZyY?= =?us-ascii?Q?5pA7tRE37/a606J5T7cjbHvy7jZFKlERIitt1kZvnmMjbQ2kFICln4KVc8tg?= =?us-ascii?Q?Sz2kGwLrM642DTVNu1RWgH+eecYL3SGnOsh/OQ4sX5/c8fqG+xMQUpDZIOvn?= =?us-ascii?Q?WQlZeuflOXTfd9aE0Rl+s9YmsNwwjJukAWDJPl6rXW8TF/EixGVKf6s40qRW?= =?us-ascii?Q?wUH75MvfWlnX5q1z0U6KEoq35nzmuVDyo43J6Ood?= Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: nic.at X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DBAPR03MB6358.eurprd03.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 95ea2902-8fd3-45bd-19fa-08ddef16badf X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Sep 2025 20:31:45.9798 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 6da68bb1-2470-49a3-8e7a-a343d51e9234 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: RQSzdeB0RM39HNK/4V4x4rF8bo3/FTFlUqQd3MtlEVOd4917jOq8BWLlc7qE/wcdgTbfEilj9sN8n6z2GO3fkg== X-MS-Exchange-Transport-CrossTenantHeadersStamped: PA3PR03MB10961 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > > what could we expect (in term of downtime in both worlds) ? >=20 > Usually seconds, so plan for ten minutes. *lol* So true ...