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.96) (envelope-from ) id 1wC9QY-001i96-26 for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 05:01:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wC9QX-004lQP-0A for pgsql-hackers@arkaria.postgresql.org; Mon, 13 Apr 2026 05:01:37 +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.96) (envelope-from ) id 1wC9QW-004lQF-1n for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 05:01:37 +0000 Received: from mail-japaneastazon11011058.outbound.protection.outlook.com ([52.101.125.58] helo=TYVP286CU001.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wC9QO-00000000k9u-0ASP for pgsql-hackers@lists.postgresql.org; Mon, 13 Apr 2026 05:01:36 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=NdNjgxl4a4y/7RG95E3j8DX1HqAOZyNj8UU2iYfe9lFJwz8YXnu/a+1A36huEZ0J3scpL2q08y2fvtKU39wUO7hRdPg/OcJp0s302NvTRZ1fBrG/aehKyJampveH+j1jJVdqNx7zP26u5M75w2ynaIAkeLbD80+1Q5VmmkhWvuGrCkbnMN31BuhVz3MVmfQwW1YK9TIwQFmQ1oC+ZSXTKj3VbKuqynsgu8WIsDYYoUimID1jljGYF4Ml+WJWM/PqkgmcFGuAq54BFnggvpM1dJCOCVa7xdIqNX3Vp4FNJkErvYqqIpiPwkhAAF+tSVFIZPMDWBvkJuqioCVpmb2OUw== 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=Qn0N8mkkzi+e2+VrfaExyvxrz3x1h5iXpXBuqimRvjc=; b=TXtEEBAAjF3bln/g4O6q835kQHdDLrN8C7wX8awoZg/Kfb7IXETLsN65n0J/0xAB96XvbTDAlmk2U/kaWYXaQcIe1wvI/IXpyfH1VpOG4DsTK4XMIq8tEamRxLYZNEZk31xzrr+aBjt/OTG/Cn0KJIXIcSZdQXshT7ZAIt4J8RaFztyf7dFiXkXZ9F87sY0DQ7of3IX1G6WrdEAQAsrPQUOzxwV9fL5q2v4b7UfKoUQYrZw0E5oSJmkyzRVR5fB71cRTNSl/hOLNcKEBDhsE4cOCP1etOj2ooSW4mG02q1e6YBh4RBWNM9iVIvKpxYhHA9jGvJS2ttrlkah6NfxMhA== 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 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fujitsu.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Qn0N8mkkzi+e2+VrfaExyvxrz3x1h5iXpXBuqimRvjc=; b=bcOlfi8uPI4+4BJpGbDH0rKrX3oLtrWvKnnRnAUxhTBUcFoh45cCEbDCE2H6JTY3O9cJ+nlnQLOYjNUmPEn9hq2DZkMdgv1oZvvA+DZ/ccyMfcQcKDRec3AR4PH1WrNGlW3PT1UuuQv5cpryWADyxBhDXwwIqB/2Dyi5wqwohBssDzqopqGeZBzmKeU9rMuIkwSRTxGoSNO0kfWZ1zFakyq5jDCAo8apvL3QrYE0WecCES1kVK8LqH561lulK+lddQzItoj83Hf5LrhaaJfhJTbYfF9/mow/AKxaL/dP8vCtmqqQfm1o/mnZKHZMSuBCWjW0fjr/ivUJ5+n+HGpagQ== Received: from OS9PR01MB12149.jpnprd01.prod.outlook.com (2603:1096:604:2e5::8) by OS3PR01MB9913.jpnprd01.prod.outlook.com (2603:1096:604:1ef::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9769.48; Mon, 13 Apr 2026 05:01:22 +0000 Received: from OS9PR01MB12149.jpnprd01.prod.outlook.com ([fe80::8943:2365:dd16:e893]) by OS9PR01MB12149.jpnprd01.prod.outlook.com ([fe80::8943:2365:dd16:e893%5]) with mapi id 15.20.9769.046; Mon, 13 Apr 2026 05:01:22 +0000 From: "Hayato Kuroda (Fujitsu)" To: PostgreSQL Hackers CC: Alvaro Herrera , Andres Freund , Kuntal Ghosh , Michael Paquier , Tomas Vondra , Robert Haas , Thomas Munro , 'Tom Lane' , Andrew Dunstan Subject: RE: subscriptionCheck failures on nightjar Thread-Topic: subscriptionCheck failures on nightjar Thread-Index: AQHUwdOQzVBeZs6MA0CaEGCNS7Q6KqXdC6SAgABUQACAAAPFgIAAB2yAgAABMYCAAAThgIAAA6mAgAADQICAAAKEgIAACroAgAAcQICAABCNgIEcJbuAgBTI+ACAIrv+gIAADISAgAAz3QCAAFd5gIAApswAgAC5NgCAAGuOgIAAfPCAgAHrQYCAADb+gIAAEPaAgAAGiYCAAAS4AIAAAv0AgASURYCAC1vIAI6mD/6Q Date: Mon, 13 Apr 2026 05:01:22 +0000 Message-ID: References: <20190920220620.GA5214@alvherre.pgsql> <4218.1569017822@sss.pgh.pa.us> <31bbae1d-1670-df3b-76e6-2e8ff8e66642@2ndQuadrant.com> <8043.1569894006@sss.pgh.pa.us> In-Reply-To: <8043.1569894006@sss.pgh.pa.us> Accept-Language: ja-JP, en-US Content-Language: ja-JP X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ActionId=88f03292-d164-4fd8-8390-a742bb810b25;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ContentBits=0;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Enabled=true;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Method=Standard;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Name=FUJITSU-RESTRICTED?;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SetDate=2026-04-13T04:51:10Z;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SiteId=a19f121d-81e1-4858-a9d8-736e267fd4c7;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_Tag=10, 3, 0, 1; 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: OS9PR01MB12149:EE_|OS3PR01MB9913:EE_ x-ms-office365-filtering-correlation-id: b708021e-74d7-40c8-49b9-08de9919b54b x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|7416014|366016|1800799024|38070700021|22082099003|56012099003|18002099003|1580799027; x-microsoft-antispam-message-info: BlzlLqMrXB4cWbmBeMMNExl2aRWJKVJT8sHEOq9CJDhlRnvoZPdceVLll3ZxpDDm+jTpb/M6WjxfH5RF4VCRshGDnZYtz/bbFRLJQrhTXHYRFvZxkHup5KUleVUONw6TFXOsCun1zzhR+UvcKvZDweRtxcSp6aQ/wVJHd3EZs/6dVn7ZDM/TeJwI7N+JmgS3yoVED+TJbnwc0paWlrl+jtxf8X5XVGo+BxwlIippQS7+1tYomNcwAnI7I16WaU+6kqns+xc0IZUbx4wAU9LHBrVC9SMRATI+TFD45u9TfeRhrLHFWj4HZWsWVDOu9cqAWRU5XD8MmaV6q1LIKDVfMdHlMr6wb3EcJtHU0ciqTKjdSssO+C+XKp4rrOkvWRixn/j1AKxLZCbW5YC/NHt99mf/oozjOoOfcb63oyrnZzF5nfFmV3+E07KvMeJzwz2MzUTlGSlc5/dZg5aO87pP1VCpX2sSJwUuq0oyaNdBSG8KxYKbN6Pkpgj6OKhA4k7Cap9J8yBUpRbYtPatl//IhQLCiOqclyNmG47dS+JeDYOW80YHPo3IXXFdL/VN4KX/5g2SXekQu3j0hKQZJobxrQYE/SRisrAGOqqoAO2qPcF+MqMyrK+Kosmqh8AkWLGHh1B1MSnhIz0GN47ioaqfcFC2rUmoV6NmTfCv+E76PatOhl0lOE1IVhZLaM2Xf42cXJiQl7bWvavrayjEFg8+x0UoH/0N2cYi4k/436CCAy4EyQiZhtJSoHbISfwRyqOR0gloUSb9jiq9LgUKXOh49YLS0qU7kSH+LOxXzrfK5N8= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OS9PR01MB12149.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(7416014)(366016)(1800799024)(38070700021)(22082099003)(56012099003)(18002099003)(1580799027);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-2022-jp?B?QnRWSHZlcVRHKyszRDIrU0ZUN2tNdjZlb2NkL1huZjFWOVdCWjI4SDJ5?= =?iso-2022-jp?B?R1lsN2h5OWxRN01WVTgzU0RQb3dWTktpTnA1SkdxMmlvS2UzN2taUjZy?= =?iso-2022-jp?B?NVFIUjNKSHJVa2U2TmZFUnFQVDZzbTFKNG0vVkllZEhXUS9jRjhQSTQ4?= =?iso-2022-jp?B?MmFKN2xSZVhqNUNKU1R3anJZTHBBRmtHMXNyZmM4SzY2bVB0SEtKaCs4?= =?iso-2022-jp?B?b0xqYlFWQVBtT0JoOFRIQlhvMW5CVkJEQ3YzbnlmdFc3UFhPWTdmTUdV?= =?iso-2022-jp?B?RkdQUUFzMlpTdTV3MFdXdSsvTnRWa3lYVlBvdjNrckkxSURLZHlpRWh2?= =?iso-2022-jp?B?eUJmb1ptUlhqaTNTMWxLc1FMNnJQVVpHMDBVelZuamVybml6am0xbUY4?= =?iso-2022-jp?B?QnNVTFpOb25Qek9zNitJdTZOelc2Mk5XRGdWdm42b25QeWc5WFJvZUVw?= =?iso-2022-jp?B?OUVMY1JaQXZFK3R5STA3NEU3UWd0akhRV1d2Mkh3My9hVGVYRzdwRDJR?= =?iso-2022-jp?B?Q09aeW9KUDVSY2RicE1VeGt1SnFxbk8wRUIzWm5OS2Jsamp3bUdEZ2lm?= =?iso-2022-jp?B?K0VFb3hYUC9xcE9NZUJxa0RUTUN3Y1pIMUs3MnBROThzUzdlRU42VTJh?= =?iso-2022-jp?B?MHRQWjJubUpzSCtSWHhBb01GZEc0cytBeThNY08vb054QVNmR01kZ3d2?= =?iso-2022-jp?B?MXNiUHBBRThXeHFkTElIZktEdGdZeEQ3a1VnVm9kR3ZsQkg3NThYSVBK?= =?iso-2022-jp?B?bm1rK3A2Zjl1NGRrK3M4M29iWStWQlFPL3Fhd2kxNGZXY2ZuUDdHTlFr?= =?iso-2022-jp?B?RU9zRGk1OUFOcVQrdDhSNWd2dWF3eGw4R3NVZVpZWXgzQUdvWHdEdFIz?= =?iso-2022-jp?B?WFE1OVN1dXhKR2VvbHZUUFR4Uks4ZWNHZFVMbWJ5bDVsazNqTWJlWHdG?= =?iso-2022-jp?B?cERxZHhOdHpnN2pRaWYrTm9rdW5kK1o4Nk9Gb1oyZklmTndUdmxoOWc4?= =?iso-2022-jp?B?WHUzU1BSTGRVLzBjUStMTm55QWJvNGxTT3ZWa2t6ZmRXSlBEVExxd2VB?= =?iso-2022-jp?B?bUN1OEZ3c1NxRXRiNXd2NEV5eWdyRW1EWUxLZ3dXcnFRemVXdlVaVXVz?= =?iso-2022-jp?B?MG1oOUc0WkE3QWF3a2dqUU1SZUhQcFhCaWtCeW9aVTlQTkpDZWdIUjVZ?= =?iso-2022-jp?B?RzN4UUwrMFJzSGQ3NnNzd1hWWERRTVZWcGhOcXZYbE9tMzJTRCtaNEZF?= =?iso-2022-jp?B?RGZSV3VNODU0R09WVXUyK2pKRkc0eFlnYVo2aFlSdjNiR3Z1YlVXMWho?= =?iso-2022-jp?B?M3U5M3pLSFdpbkZXTmxhME5IMDZEazBrZEdXMGJmeFJSbEVmU3N2KzhF?= =?iso-2022-jp?B?WDI0bHV1QmhycWhvN1VwdE9iL1BkektpWFFpbnpGQ25wa2xTWDJYTFQ3?= =?iso-2022-jp?B?dWFucWlBMEllN1U2T0tQYlcraG5xdXdFM2RjMEltV0xYVEQvUGMvTjRW?= =?iso-2022-jp?B?d2dNT3R3VWlML2lXSERkRGMyWSsyQm1yWTU4cWpDSWhJVEJlNzlENlZW?= =?iso-2022-jp?B?aUF0NlpPR21ZZFdKZzNUQUxFWUhCUG0xTU9KYUJhSnJYcmdPTHRoQjhR?= =?iso-2022-jp?B?Q29hMDNCcFA0V3FTMWR3SzNXMmh6dTg2L0Exa1JXRWZ3WXNQaVphVEor?= =?iso-2022-jp?B?UDhmU1dNTFJoakJMbUF1ZVU2K0RFTmVtNXpWNGRDVjBWZFdZWDRPeWh4?= =?iso-2022-jp?B?UGxGT3ZvMi9FMXpaZnNzOXZBYmdUMjdYclZJUUZsMlR2YktZUWUreWRM?= =?iso-2022-jp?B?UkttOE16Wm1jQ1hyWkMyb1Bqa3pLdE5sbmlGc2RTUElLQ0lFbUFPSVM3?= =?iso-2022-jp?B?NHNnUVA2OFNjbFk1bWhyMENxa1o1d2NBeENrWGNqQkVKUWcvd2FCVHAv?= =?iso-2022-jp?B?YlRJTXUyNm91NzFMTi9mVExUaXA0UzkwWWNMNy9RNGdZbGhjYUkxNlVP?= =?iso-2022-jp?B?Y3dHVWRwaWhCdmtEWmZZUW92Umg5aHQ3eE5hVHB4bitWckRpNFQvV1pD?= =?iso-2022-jp?B?dStuUmJNcC8rU1hqTXFhYnh2dHF4NXhZU3NaN2NDcnI3M1RTTThxbGsr?= =?iso-2022-jp?B?dkgzSEhycE1qajY2RVNsQXdSNjQvQk9KQy9BMWQzWmQ1QmxhNnVBWU9w?= =?iso-2022-jp?B?MkRTK0ExaDV6WmJpYVhRaFNUVmpla2w1bjB2c2VvdkkvZEM3ZVRiZW5E?= =?iso-2022-jp?B?Z0JOY1pWL3FoYkMvMitMN1RpQitFNGJQaWRva3JRN2R4aHkxMjlQQlNX?= =?iso-2022-jp?B?RlJ0OFZYUHJicG12cTg3S2lPdGZ0RHVIT2pRanV1L2R4L0ZrU0xiSEp5?= =?iso-2022-jp?B?VU1HMmhWdG42ZGlFS0pHQ1dzUzFHZVpUT0l1SFRncmxidFo4dWVwbE15?= =?iso-2022-jp?B?TEZBRUs5ZzBFNjVZVUxZeTNtUEJ0Wmgxd3ZpbmtGMWNORzBra3hkZStn?= =?iso-2022-jp?B?WHhhMlNiK3FHTzk1L2ZyU3h0M0NWRzYyeDRHTEcvRGRBR1BtTSs2bzVo?= =?iso-2022-jp?B?MitVQ3FDST0=?= Content-Type: text/plain; charset="iso-2022-jp" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Exchange-RoutingPolicyChecked: mQhTlkbOSoZzy2yXJtC0NRu2JfpdPh9U8JhKkUr8XwnVGRAIiQ1XO7yocFR7qhIMRZN3Tkx9wrPrD8E7UaBxcggVrcrLDJA/ey8/iiQ5AeYzHYuGJMj0JfQTxRJq5TiSczigUt+8mvD5NgJvQqY1iqI9SCRQiFZ2rwtRVZDX4ebTu14aR6H3M+i78JoUzZ4XRR5UzF1fB6mDvcarkxE5AjHPuS6BPIj9fsu2f9qR2REZtUGL2wOKHuVrTVxM/OwG4XekrshXXUan0SoDPFBspTQGkHwOUndY4P23e9Rwir0I1TIERDupQgxc8dke5WFzFHDDaMfCMa2uWaw/2ayYsQ== X-OriginatorOrg: fujitsu.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: OS9PR01MB12149.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: b708021e-74d7-40c8-49b9-08de9919b54b X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Apr 2026 05:01:22.7809 (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: l6ZOzJX5dt18ODjjfbUbG2IEw2NSIBeFUPz3Y4xg6Znj997DZ/lKpAz1NAHP34YBNBIdGyO1YT4njqAdONFrjjyS3DYkh2LOYNuCLVPVzjA= X-MS-Exchange-Transport-CrossTenantHeadersStamped: OS3PR01MB9913 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi hackers, Sorry for reviving the old thread. While digging threads related with the recent BF failure [1] I found here. And same issues were reported like [2] and [3], everything happened on the Windows platform. Per my quick lookup of this thread, the issue could not happen if rename() works atomically. I'm not sure for Windows env, but does it mean We do not = use atomic renaming on them? [1]: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=3Ddrongo&dt=3D= 2026-04-12%2003%3A43%3A28 [2]: https://www.postgresql.org/message-id/flat/17989-6b9f058bad9cd31b%40po= stgresql.org [3]: https://www.postgresql.org/message-id/flat/18638-760882b4e5851b71%40po= stgresql.org Best regards, Hayato Kuroda FUJITSU LIMITED=20