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 1rDefs-002hj6-7f for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Dec 2023 05:54:20 +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 1rDeeq-004F0d-Iy for pgsql-hackers@arkaria.postgresql.org; Thu, 14 Dec 2023 05:53:16 +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 1rDeeq-004F0V-3b for pgsql-hackers@lists.postgresql.org; Thu, 14 Dec 2023 05:53:16 +0000 Received: from esa7.fujitsucc.c3s2.iphmx.com ([68.232.159.87]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rDeem-00AJMR-Hn for pgsql-hackers@postgresql.org; Thu, 14 Dec 2023 05:53:14 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=fujitsu.com; i=@fujitsu.com; q=dns/txt; s=fj1; t=1702533193; x=1734069193; h=from:to:cc:subject:date:message-id:references: in-reply-to:content-transfer-encoding:mime-version; bh=cL02ZlfbAaHG1wup9gNVkCFtyEEGdgyQIRcrC1aouM4=; b=GD3ff7wj1EuGwkHKHTGE4hJw1sYSm42LZHR/YzX114f3hFIE0RbchrrB xqnuRSvWDAtYe+Oqdj8kq2MQ1KUxsSG0zp0Wj2CHKGLuf9sE22e8Xec2l MO5vE+HS/o6c5JpqhXjzRo7kZxiNzQZwLi+u0ZUGfdgKw4jRmdC/bXeZd IGSI8vcJ5S8DFl1CQM4aG3+a6+3NCMOL7tSodfaYe7MPua4SwVudwo1c1 g29tnzX7zjHokT7GTfr4xjPqVUCNecjnfMffrrlxFdIv/CLHkfTh3/eC3 49W2y36idiPq+1S5mQm5fSKCR/uVadqZqealg5nadwX03bVCkSM2wxny/ Q==; X-IronPort-AV: E=McAfee;i="6600,9927,10923"; a="105713096" X-IronPort-AV: E=Sophos;i="6.04,274,1695654000"; d="scan'208";a="105713096" Received: from mail-os0jpn01lp2105.outbound.protection.outlook.com (HELO JPN01-OS0-obe.outbound.protection.outlook.com) ([104.47.23.105]) by ob1.fujitsucc.c3s2.iphmx.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 14 Dec 2023 14:53:06 +0900 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=JfuEbG8XjAiQbDYCpfvq3jcEmd1Mg/jZU44R1NmZdVCjskJgXodUUcegwYgcRjppar2Aj4Tyil6lW1Pi8sRwi3D2rJJBxTZzTVwRIK63gJYjhmMMwge/sNjwe03DweZxY+tpi7FcIu0VA6JjoQCub8UXom2OB5oksx8wnlkUC9T1FWlBu60fbcxgBk+MuCYn32fm/kz4+HCQ3ctqjo10MS/8raWZRkc6d2Lv/iREkgeLukYhivg3n7wZn67iTWGLCH/BtpvjzYP+MeZphCmwdhrnZd/rEFH5hIm197mvFoZLFBKamQvZWrIrib9bjjeMCCYbA98JpR3viGyr12kc5w== 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=cL02ZlfbAaHG1wup9gNVkCFtyEEGdgyQIRcrC1aouM4=; b=QKky7fvbCQhjHLFR19PWDQUtEwo5TDi/2Zp/tATZ6Vb3L0iZMUk8PYaIVJdduznDaoINcVCthd7fk7NBcxEDG/DNvB02UjnTopAZMEuQ/KmPt8bnprMEEK0Wv1zNEndpYSevQ5TsnFyt73Cyn6vkEMGgHLX2wCASl0EgY4hAJjfPSjKc89xJ1eQsKqjFAU6E3b/5ozKawLWqmJB+DWfcDQ0WsVA8mQ+8ILvrl1yHe2NLQkwnuoG+qJpFDavUn0kbbvAmSXZsS/163O/eWmU/U7BqmppGfklf2K/ksQytPOlq6OGBLxv8Bzs0vztoz5dQt/WCCpMfbfRnskmBBYx6XA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fujitsu.com; dmarc=pass action=none header.from=fujitsu.com; dkim=pass header.d=fujitsu.com; arc=none Received: from OS0PR01MB5716.jpnprd01.prod.outlook.com (2603:1096:604:bb::12) by TYCPR01MB8519.jpnprd01.prod.outlook.com (2603:1096:400:153::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7113.8; Thu, 14 Dec 2023 05:53:02 +0000 Received: from OS0PR01MB5716.jpnprd01.prod.outlook.com ([fe80::638f:c5ac:dcaf:baa1]) by OS0PR01MB5716.jpnprd01.prod.outlook.com ([fe80::638f:c5ac:dcaf:baa1%7]) with mapi id 15.20.7113.008; Thu, 14 Dec 2023 05:53:02 +0000 From: "Zhijie Hou (Fujitsu)" To: Peter Smith , shveta malik CC: Amit Kapila , "Drouvot, Bertrand" , Nisha Moond , "Hayato Kuroda (Fujitsu)" , Bharath Rupireddy , Peter Eisentraut , Bruce Momjian , Ashutosh Sharma , Andres Freund , pgsql-hackers , Ajin Cherian , Alvaro Herrera Subject: RE: Synchronizing slots from primary to standby Thread-Topic: Synchronizing slots from primary to standby Thread-Index: AQHaJE9sgJJNJUqALky3mvuBKJq3g7CYl8uAgAC/xgCAANHogIAAa3WAgAArgoCAAQCOgIAADoeAgAA1dgCAABjKgIAABtwAgAL+XYCABKJcAIAAQJWAgAK2zQCAABFoAIAAWssAgAEfIoCAABH+QA== Date: Thu, 14 Dec 2023 05:53:02 +0000 Message-ID: References: <6694284d-c847-42df-8f76-6efa8eeeb0df@gmail.com> <2fdc471d-2eee-4c29-9f26-d7f5dcc8cd53@gmail.com> <25e30b80-14cc-4dce-a4d0-8715181cd26b@gmail.com> In-Reply-To: Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: =?utf-8?B?TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5LTQyYWMtYWI0ZC0zYjBmNGZlY2Uw?= =?utf-8?B?NTBfQWN0aW9uSWQ9NTFlMjliMWMtZmEzNS00YzRhLTgyZWEtNTdlOTRhNjdh?= =?utf-8?B?ZWQ1O01TSVBfTGFiZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRm?= =?utf-8?B?ZWNlMDUwX0NvbnRlbnRCaXRzPTA7TVNJUF9MYWJlbF9hNzI5NWNjMS1kMjc5?= =?utf-8?B?LTQyYWMtYWI0ZC0zYjBmNGZlY2UwNTBfRW5hYmxlZD10cnVlO01TSVBfTGFi?= =?utf-8?B?ZWxfYTcyOTVjYzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX01ldGhv?= =?utf-8?B?ZD1TdGFuZGFyZDtNU0lQX0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRk?= =?utf-8?B?LTNiMGY0ZmVjZTA1MF9OYW1lPUZVSklUU1UtUkVTVFJJQ1RFROKAiztNU0lQ?= =?utf-8?B?X0xhYmVsX2E3Mjk1Y2MxLWQyNzktNDJhYy1hYjRkLTNiMGY0ZmVjZTA1MF9T?= =?utf-8?B?ZXREYXRlPTIwMjMtMTItMTRUMDU6NDk6NDVaO01TSVBfTGFiZWxfYTcyOTVj?= =?utf-8?B?YzEtZDI3OS00MmFjLWFiNGQtM2IwZjRmZWNlMDUwX1NpdGVJZD1hMTlmMTIx?= =?utf-8?Q?d-81e1-4858-a9d8-736e267fd4c7;?= authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fujitsu.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: OS0PR01MB5716:EE_|TYCPR01MB8519:EE_ x-ms-office365-filtering-correlation-id: 1e152e4d-fc77-4a75-77b4-08dbfc68ef59 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 6NaPyzufTdUQ4mjAklNyiO2BueyDPu2EBXcJ8njPPydejpiSAREaJCSshPsWUme/efw9iwXSyBrFWpcunQiJ+/MAql8a3GdNVQ+QmNoDGCPYqb5laaTx4h0YO2pf0c4Dl/+JirLnIoLQ9V1tAoKEvxGZ/R4zdGT2pWL3qc0ifnJ4NBoT5aSQ1CjikeP6i9V+zoQlsej11EJZkBmzTjWCM4aHnGom11NFZy8DclZohSv4lvF4vk3hOJtQGIDzT21Cm6E5fJHleXzWSNfHrE/3S8viREHttlUUoje/U+vmIQ43APnixgvW9efSeyr2dV3MOq+UGlVOit0Sfm+Y1ASUb6X995OGHQm/M+zrN/0uRKwVa3feFLk1Bb+7sHNUygheUJS/C3ekUS2LvL1nZwkYKjaqWqskcwTiU2fUBCySa7leB0Wtzdf690tlSkZJKut3PWtJUgvc1abKPwfDGwzqxM8r/a0qFqoDK8W0G70MM7ZeUpmK7nw6g3+mmT4pnsThBNROUv5we8h6Yj/zh86xXwMv0XiWMgdhwoRafgjowUkgG21RhQwhXR0zoPsLMbXgwIcCRfi5OghOgkPAmVHeUpwPo8pqdWv+gvO/tyYPqqQ9/UiHzO6FmAEKAwdzgstK0CuFJaQQ6zXh68liYn64cw== x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS0PR01MB5716.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(39860400002)(366004)(346002)(136003)(376002)(396003)(230922051799003)(451199024)(1590799021)(186009)(64100799003)(1800799012)(122000001)(1580799018)(85182001)(41300700001)(38070700009)(7416002)(4744005)(5660300002)(33656002)(2906002)(82960400001)(6506007)(71200400001)(53546011)(7696005)(9686003)(478600001)(26005)(8936002)(8676002)(4326008)(316002)(110136005)(54906003)(64756008)(76116006)(66946007)(66446008)(55016003)(66476007)(66556008)(86362001)(52536014)(38100700002);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?dWE3SEduSHdXOVlVZ2dreEFtTGlYOFZvSCtGUCtJampER3FrQkZXRXU4YXpQ?= =?utf-8?B?TDMvSjMxcFRqaldadmdSSGJpVGR1ZklocVFQLzlRWjhWY3FWS2s3TlpJMW1l?= =?utf-8?B?aTVOM1Z5aGJja3JJRnQrbGQramtyYVp6MEsvYTFCSlJtaCtoNThkcmZjbSsx?= =?utf-8?B?UzZtSmpqRXBIK1g1Z21nMzhQV25qdGNRYVYxMWczckRLSEpnczhabi9SaE9s?= =?utf-8?B?clNLbDlUeDZLaWI5ZU1EL2oydEMvV04relM5RDBrOUh4cGVyM25jVTVyL0tw?= =?utf-8?B?bGN1emlHME5CTXNYWXFMdldEM1RrRmdkekhxV21IdU1sbGlLRGc2WHVKbjky?= =?utf-8?B?bnprKzNBaEM5eHNlR1dHQ0xTTVBKWEJkcExKd2ErYm43a0xkLzNqM3Arb3dt?= =?utf-8?B?ZmYxbmdTK05TdVgrcFVLVFRhRFlsRFNwbnJLSGZaSmFHN0Q1U2EzUU9SQTRu?= =?utf-8?B?ek0wbDJSZ3pabjd1ZjlHQ2txTFFmSjhNTEhEVlIrUHlkVm9LNlVrYzZXYlBa?= =?utf-8?B?Z2VDbWNJQUlxMGc4d1kxaDUwdmdKN3VFUFNNYk5wZ3JFRkFzR3g0RjBzR2NW?= =?utf-8?B?RENEQVcraThuQmNsK3Uyc09EZjVhYVBYSWJkMWtXa0Y5UU9xSDkvRjE5RVNn?= =?utf-8?B?Wkl4dURUSHA5WUp6TUVob1ZTVVFnQWE4ZkRGbTdHNDZPa083OFZGYTI1bXl5?= =?utf-8?B?TzJrbnNsdzJOQ0IxYXB2MGRoR25lRllCRW15Q1p2aVFseDRFcFZvWkU4Uzlx?= =?utf-8?B?OC9yVkZoUnluYVljY0t5TVNWN3BnbWxSSUpkQmRUSDNxQkVnSDBnd2FENVRl?= =?utf-8?B?azFTSk5TZTRWK2VqL3lNNnVWVnJFT0lLbzlRTjlUWG9NTVhXQjQxYzZUR1Q5?= =?utf-8?B?V2dWYndOZkF5TkpKQk8zaUdua1V0Z3NZa3p3OGxac1ppcmh6d3RWZUJxeEw2?= =?utf-8?B?RXZFWWNtMlZpcDZLa1J5N3V5a2g4WVdGMDdnSTRmZUhaSmp0WkpvY3h4QmNs?= =?utf-8?B?OWxzcEplWHlhVjdwV0gzRmlIcElZSzJOVExJTnRGV3pOM0J3MWFpSkJtRmVT?= =?utf-8?B?MndQV0RoZUZkTVBJWC9lM1RxMFBIVzVuMld5bDZJR0paTDlGSW94aGNKTjJE?= =?utf-8?B?K2EzNW43aytFRk53Uzd5N0hSKzFTUUtQNjh4QVFodWgzaHdyUzAvNjhjUDdY?= =?utf-8?B?cDF5WU1jcWhtdzBuWmNHYzdGVm1IcDVkalRHU1VhNWFzM1pqbkRmd1BsL1JK?= =?utf-8?B?VVZ4LzNRckMyZ2d1NXU0YlVnSmoyeE5DcHJrSEMzY2daR0FDUUJoYXhDRC9P?= =?utf-8?B?R2hkT1dSWVg0SXJ3SWRFTFJNNHVJUmJzZll4VllkekVkaTZueFpmc3o4U0d3?= =?utf-8?B?SWIrSXk5UTJDVHRUQm1lUHZ3S2dJS0h5T0lycjRzdXByaEljdGI1c3Q1ajdk?= =?utf-8?B?QWtqVzJnYlRYU21hYXVHTFFjcDdhbzA5SGtmUVJ0Wm9jazIxZlQ4RkJ6ZHBx?= =?utf-8?B?QmxYZjJkQzA0dmR1aXd0MGdrVjdydUlsLzViWVJrMlRxc1E1anBrc09idE84?= =?utf-8?B?ODlkNUJYQlB2TThjdVBsSyt1VVY0N2lPdjRGOHVmRFM5RWhiVmZ6MjVSTGlG?= =?utf-8?B?NGNnYXZlb2pTOG5YK3BOTWN0OXh2ay83eWpSVUFaM1NRNThlU3RLdEMyMmlS?= =?utf-8?B?bGRQcmtSUUR1RkNvOHdOcUFpN1Q3VHB4RVNiL3VGOGtrM2hxaFpCMGh5OUkz?= =?utf-8?B?SnVoWnkwWCt3YzM5b0V0NVVDUDhrbzkwbkZ5OEdMa2N0Qnp3YXJsRjk3ekVx?= =?utf-8?B?RENWeEFNTmpTQXIrdndsVlJZQndPL1VaMktFTVRBdXJSa1N2ZEJYWlloUG4y?= =?utf-8?B?azhkdmtpOTA2TEsvMW4yR3NlR2Y3ekR2SmpaYjZHV1hUbEw3cmRyVDNKZ3Jr?= =?utf-8?B?TDUydHN1eTJWTWZTTDRDdTQ3bFZQdmlQVmJIRDA4djBvTXBKUFlLb3AyVyty?= =?utf-8?B?UEJHdFpvSCtxd3NLYUJUTFhHZkwxSi9Ud21ZRVNJc082YnJjNWFNYmtrVnBv?= =?utf-8?B?amh3MzN6WGE0MGpwVUpSL0FmY2FIYnFnWGRJU2loamxOR0Q2SElDTXZKU2R3?= =?utf-8?Q?tALi5FHLTITNBUv2YR5PFg+0e?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: /qXWYiCXaLA6xDUrB3tPe13na30xO5ndGVAI/CiF6LSOaOmRf4RbTVzhoib5UPVRwlhQdduWfX9mkWrbCBhb6YxmVLtiPP2CLSPmhgjxsXxZWZYu7RNehyMUNjazpYyRZWkqHa/DXj3eJ2mtQsTV9WWx79Hu0xIrKcmWLbPlryCjb5HB8TInzeh8/KvFMWOmzdM1+D4OpVYhXLveq2bD/FFNOUQoGs5u5Kzc+GkJJcOIqO77f5GqRbZkrEUJxmpWe4bRzuYvahwQHGSdtBjrbNsezC+Srj2zp8q8saq7cLjXGEE40CWrU9RAaTuwr03IDnZYa3K89uHtvast46gznoBOE5fBpamezANbUAhtqkvE8B4Hmppo+b35M/QfggsXUXIhsPaayYYRKsRB0789ShDYEEKDdeY6uiRrBA27GJYg7ZR+jcnOLhRlL6qreX81Kd5okLPZGhFf4hyB1osfqSPoffyutyWA0JeRQbKdxtg3aAZETjBFHXTBujN2+qNalp3o2a6tlHYXvSYzOSg+nxY6dBsayczbrRu17/mwz9n++kyliPkitpqfTFnFstz6fd59Jn2e7GFLW6WT7bGutYOJ+SrBh5+FYO6B8bgCzm2mpjItDS6YsNBX49vLxGQP X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS0PR01MB5716.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 1e152e4d-fc77-4a75-77b4-08dbfc68ef59 X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Dec 2023 05:53:02.5391 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: a19f121d-81e1-4858-a9d8-736e267fd4c7 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: Gq40h8Q3UadS0rOrRHao60lv7OTa2pZXhhBLguUY21tv/gNHLwG2lX12MlGp0fueRphN+5vACB+7uMWmbr2Mzg== X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYCPR01MB8519 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gVGh1cnNkYXksIERlY2VtYmVyIDE0LCAyMDIzIDEyOjQ1IFBNIFBldGVyIFNtaXRoIDxzbWl0 aHBiMjI1MEBnbWFpbC5jb20+IHdyb3RlOg0KDQo+IEEgcmV2aWV3IGNvbW1lbnQgZm9yIHY0Ny0w MDAxDQoNClRoYW5rcyBmb3IgdGhlIGNvbW1lbnQuDQoNCj4gDQo+ID09PT09PQ0KPiBzcmMvYmFj a2VuZC9yZXBsaWNhdGlvbi9zbG90LmMNCj4gDQo+IDEuICBHZXRTdGFuZGJ5U2xvdExpc3QNCj4g DQo+ICtzdGF0aWMgdm9pZA0KPiArV2FsU25kUmVyZWFkQ29uZmlnQW5kUmVJbml0U2xvdExpc3Qo TGlzdCAqKnN0YW5kYnlfc2xvdHMpIHsNCj4gKyBjaGFyICAgICpwcmVfc3RhbmRieV9zbG90X25h bWVzOw0KPiArDQo+ICsgUHJvY2Vzc0NvbmZpZ0ZpbGUoUEdDX1NJR0hVUCk7DQo+ICsNCj4gKyAv Kg0KPiArICogSWYgd2UgYXJlIHJ1bm5pbmcgb24gYSBzdGFuZGJ5LCB0aGVyZSBpcyBubyBuZWVk IHRvIHJlbG9hZA0KPiArICogc3RhbmRieV9zbG90X25hbWVzIHNpbmNlIHdlIGRvIG5vdCBzdXBw b3J0IHN5bmNpbmcgc2xvdHMgdG8NCj4gKyBjYXNjYWRpbmcNCj4gKyAqIHN0YW5kYnlzLg0KPiAr ICovDQo+ICsgaWYgKFJlY292ZXJ5SW5Qcm9ncmVzcygpKQ0KPiArIHJldHVybjsNCj4gDQo+IFNo b3VsZCB0aGUgUmVjb3ZlcnlJblByb2dyZXNzKCkgY2hlY2sgYmUgZmlyc3QgLS0gZXZlbiBiZWZv cmUgdGhlDQo+IFByb2Nlc3NDb25maWdGaWxlIGNhbGw/DQoNClByb2Nlc3NDb25maWdGaWxlIGlz IG5lY2Vzc2FyeSBoZXJlLCBpdCBpcyB1c2VkIG5vdCBvbmx5IGZvciBzdGFuZGJ5X3Nsb3RfbmFt ZXMNCmJ1dCBhbHNvIGFsbCBvdGhlciBHVUNzIHRoYXQgY291bGQgYmUgdXNlZCBpbiB0aGUgY2Fs bGVyLg0KDQpCZXN0IFJlZ2FyZHMsDQpIb3UgemoNCg==