From: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>
To: 'Michael Paquier' <michael@paquier.xyz>
CC: 'Paul A Jungwirth' <pj@illuminatedcomputing.com>, Mutaamba Maasha
	<maasha@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>, "David G.
 Johnston" <david.g.johnston@gmail.com>, "Zhijie Hou (Fujitsu)"
	<houzj.fnst@fujitsu.com>, Tom Lane <tgl@sss.pgh.pa.us>, Bertrand Drouvot
	<bertranddrouvot.pg@gmail.com>, "pgsql-hackers@lists.postgresql.org"
	<pgsql-hackers@lists.postgresql.org>
Subject: RE: ReplicationSlotRelease() crashes when the instance is in the
 single user mode
Thread-Topic: ReplicationSlotRelease() crashes when the instance is in the
 single user mode
Thread-Index: 
 AduBxJdn64KPa5CETf+apI8CWWnvvAAB/XMAAAIqX/AAASMfAAAAQnZgACfEuiAALDVUgAAE2ItwABXHEzAAVE1gAACSlm/wAJd6igAABPP04B8hqvEAAnvw1QAAAXnoAAAy/auQAAQGw4AAAGSp4AAm+66AAAE6hVA=
Date: Wed, 20 Aug 2025 07:42:11 +0000
Message-ID: 
 <OSCPR01MB14966EEA6534F4A07A1F1722EF533A@OSCPR01MB14966.jpnprd01.prod.outlook.com>
References: 
 <CAA4eK1LK5nZUWwNY31X6BUXdQwwzpKGKxnw+zFf-cWKm3nuCEg@mail.gmail.com>
 <OSCPR01MB149669CFD736D48C4450337DDF5CD2@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <CAA4eK1L8_QrYavkCy9b0Rrz8gqZRQE8kEmv3g7Tz6tsN8YuvhA@mail.gmail.com>
 <OSCPR01MB149660CD4D6648CFE7FE68D34F5CC2@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <CA+renyWi+bbD8M8CDAaOMGbUrXptKLCK8zQWEhXy00PJuJqNuQ@mail.gmail.com>
 <OSCPR01MB14966B39B3ED21229EAEFA10FF531A@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <aKLsJljQOnjBwFZQ@paquier.xyz>
 <OSCPR01MB14966D87D8EB0D9CD32C6A43DF530A@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <aKRdXV8o56mUl_gm@paquier.xyz>
 <OSCPR01MB14966F06D84A7A9C26570A519F530A@OSCPR01MB14966.jpnprd01.prod.outlook.com>
 <aKVlnTDxE8hQDq92@paquier.xyz>
In-Reply-To: <aKVlnTDxE8hQDq92@paquier.xyz>
Accept-Language: ja-JP, en-US
Content-Language: ja-JP
msip_labels: 
 MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_ActionId=07c2e1ab-ad23-4df1-8f91-d612fd2e77e8;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=2025-08-20T06:40:27Z;MSIP_Label_a7295cc1-d279-42ac-ab4d-3b0f4fece050_SiteId=a19f121d-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: OSCPR01MB14966:EE_|OSRPR01MB11523:EE_
x-ms-office365-filtering-correlation-id: cfd893f2-cefd-4a52-c2db-08dddfbd12c6
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: 
 BCL:0;ARA:13230040|366016|1800799024|376014|1580799027|38070700018;
x-microsoft-antispam-message-info: 
 =?iso-2022-jp?B?cmFlWjFERWg4QnVGSlYrWS92NFNMaTZZMkNnOFV3Mk1JZG9mZG1BcDEy?=
 =?iso-2022-jp?B?Yk5abS9wK21KNkNxUStvU21DWmVjeFZJdkFWTlY5Q2FiMzFlc1RHeUVH?=
 =?iso-2022-jp?B?VTFCMnBxcFRKT1h1MlVpZG04SzN3UWIvS3k4L1ErOWMzUGZCWk9hRDF4?=
 =?iso-2022-jp?B?WkpvYTI5MWNoK1dXckg1ZDRQbkJFNCtjNm1GcWE5NWtsbjRabXlSekdh?=
 =?iso-2022-jp?B?enBqTFZjNWg0amNPUStyY24rc0MvaXk4cnFmdGNONFpIcDVReVYwWlpD?=
 =?iso-2022-jp?B?TmNoVnFYZTk2ZHFQa2oxYkdsV3BKRGo5cEllc1FVMUlMMjJwbVJjdFpi?=
 =?iso-2022-jp?B?Wmpuc3ZITi9CbkMxT1JNQzV2U05BdEpkdHh5THZkbXhvWS9vWFl5Mzlp?=
 =?iso-2022-jp?B?RnpmNFhxZDdwM0g4UUxwNmpxQ3U0RjUyNTNWTVYzZmZ0SWZWMFloQVhO?=
 =?iso-2022-jp?B?bmZVeXdMYWpnaVBXbUhjdU5tWEE2dmM3OWRLRGRmNXc1bnUzTUt2Uytr?=
 =?iso-2022-jp?B?V2NYeTNIQmU0ODIra0hRM0lyeFdzY0NLN200Mi9nZ1IzcnZnMzJpR2x6?=
 =?iso-2022-jp?B?Y2c5c0RMWStZQ0hKUk5XckdPK0hTY2RmZCtJdmpUalcyL0VaMTNURXFn?=
 =?iso-2022-jp?B?ck9pTFB5T1RUN2k0R3pyd3IvV1BWcHJUSVF3UEU2RXRhaUtnTnU3TWRK?=
 =?iso-2022-jp?B?dHB4M1BSa1F5SWRaYVFLMHBLbXFzMVVuYW1PczZVTzAxaXI0MEhuQm9N?=
 =?iso-2022-jp?B?d1ExSHY0M2R5SVVRdWJPbjJuU2xGL29QbmdhYzhMM0J0MWJ1RkVqY0VB?=
 =?iso-2022-jp?B?VmV1TnV6YysyYzAxZzhSMzZMKzZpOVI4YnA1Qkthc1pQbW1kZEZGK05E?=
 =?iso-2022-jp?B?cjV2blRyeXZ5WCtUcXVoZGFPTUhPZUtLRHNrOXIvQU9HcENrd3FBdTNr?=
 =?iso-2022-jp?B?WUlQbXJ5RHhFSDB2Z1V2ZmNsNzF1SUVJWkFnRHZPamJNV0Y5R1hvTWpI?=
 =?iso-2022-jp?B?aFQzZHFicWFKeTdUSERXWmVjTlZpOVdMZlByQzIwVHBPOE9YTDNMc3Rh?=
 =?iso-2022-jp?B?eUxJSW8rQkl2dldVZnppdmRrTzFMODQ2eHk2UmRERDZtZUxtZ2Yza3Q2?=
 =?iso-2022-jp?B?R1gzQ3pOaVp1Z2ZFY1dHaHdMbXhybVljV1BuZ09OMFYxZVp0WkROQUtu?=
 =?iso-2022-jp?B?c2NqNldoVTFUdnZDSzZEdldudVJvdm1rKzFHcXQzbm5jbWdiejkyZEZo?=
 =?iso-2022-jp?B?WHhzVG54U3Z2dUJhM3BjSC8ycWdQNmJmUmFmbHZBd0g5eG9HOTdVODV2?=
 =?iso-2022-jp?B?MXFzQVkrdGtBeEZJNHd0U2lkYmJjRzFFdEw0dUxOZXd6VjFBOU1uRkpp?=
 =?iso-2022-jp?B?OUxvcDRxRTk0NmdJRFc2OUIyNTJuODYvbUtrNlpCTHlWT1pUKytSRlJq?=
 =?iso-2022-jp?B?aTBSZ1drUmF1c1VQNmdnaTFLclJqbXdxRDhMckh5ZXdrZXYxQU9SQ2Vu?=
 =?iso-2022-jp?B?bE9NbmVCNlF4MW5QQVFQQ0hKc3c4THVlcjB2Z09sODdoUUNJNlpmQm0y?=
 =?iso-2022-jp?B?eGlJaW1LdVpLUUV1SHdyODM2R2F5S1lzYWYxam5MeHhTS3BIZ1didEhK?=
 =?iso-2022-jp?B?TGg5UE4zWDJDcGQrdDRubXltN21kWWQyYml3N05BdThIQ1hOazBxQ1dZ?=
 =?iso-2022-jp?B?MXBaaVR0TFJZUnRFeER4S2d2eEdROHdBSWJXMmtYRmFQdlI4M2ROWTky?=
 =?iso-2022-jp?B?UGJpcE5kcTVnVDVnOUtwNDRhK1JPazdJSHdKY0NkbTNKZU5nSm9PN2t3?=
 =?iso-2022-jp?B?Yk1wMGE0S2tMUlYxK25RcVplYkhnMHBndWYvMHZJR1lMRnB5cDZveENn?=
 =?iso-2022-jp?B?cmVFeklOUFgra29wZ2IvOHdIUGg5cW03NXp6aUNsVU9KeUQySStiUDNm?=
 =?iso-2022-jp?B?c2NLd016WU1IbUpsbU5zeE9JQWowQW5yN1AvZHNBTlUrT3JlcE5BMjNT?=
 =?iso-2022-jp?B?bTl6a2ZhVFI5ekZJdnRCS3NUSU04OVp2YnJoWW5TWTc4SDl4eUtXOFhk?=
 =?iso-2022-jp?B?RlFycGc0Tk1QZEx2U2JwN3dOb1Q5MjJxZmJMTUxOQ3NQbDB1V3dlNS9k?=
 =?iso-2022-jp?B?UVlPSE5kQlNld2Rtc2xMZlhUOExpbEV5Y3hmSHl4N3lRTkhJZDJvcFhi?=
 =?iso-2022-jp?B?T3k4Y3BmVFhNSiswbHNyckkveFNta2Zk?=
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:ja;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:OSCPR01MB14966.jpnprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(1800799024)(376014)(1580799027)(38070700018);DIR:OUT;SFP:1101;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-2022-jp?B?SnZHS1NRTksxaXVaRHlyamlqVFlrcGJ0cUFNOXRON2MxTHZ3QUdRYVZM?=
 =?iso-2022-jp?B?Y3BDZmJDOVJHNmhYQkZkZGZKZUFOclRON2VkZWs2MjRYenlwVW44L2Np?=
 =?iso-2022-jp?B?ai9ZdEgyemVFRGxZY0JXdHpYWE5jeGsrY0RyZUFoNnMzRWszVWdPaTZQ?=
 =?iso-2022-jp?B?ejNvOVNXZmp1UXdyWUQvYTliZmEwMCtVK1Ewd0JIRU93MnpnQWFLUlc5?=
 =?iso-2022-jp?B?b0hjU1ZmMlFtZzhROUdOcGpYZXBDTURQeTNPL0tVR3cvMzFPMjV6M1Y4?=
 =?iso-2022-jp?B?S3ZpSTFPaEtUR1VTQVBFVEljMHF1d3ZVeTg4dHJ4RUVmeTZyRGkvWUh4?=
 =?iso-2022-jp?B?aGRMak8zWWNUOVhnUFVPalkrdVFXNmNCemp0eDI4cHFNYzJMQjBkakI3?=
 =?iso-2022-jp?B?ZEdqeWZmVEkyNkZZTUVRYzdIVXJiMUxKNFhMY1lFSlNXNzkyQVdXL0Nx?=
 =?iso-2022-jp?B?ZHFjREVDczhZU3VxSmwrMmZXVmRmcG4rTUFONU04c2xVOVpIUlhLVm10?=
 =?iso-2022-jp?B?dFJwZzNwWENhWis0blhSN3JwMUNGbm9WYVBkS2I4QVNOZkJub3Y5d1Q1?=
 =?iso-2022-jp?B?Njl5WmJ3dldsNHoyanlXRURvanZKYlhzM0VoNkplNGc2bkRnTmxwVnRE?=
 =?iso-2022-jp?B?RkhUTDVQY0VGR3REZ3VOTmkwUjIvbXpWclphQWlLa3BiK0JKTWk5U0pM?=
 =?iso-2022-jp?B?Y2d0RDY0RWpLTjNFMENTd0krTytGRFVwVTJrM0JkUEV6WUtCekdpRDFk?=
 =?iso-2022-jp?B?ZGxNMUlvYU56WlZzeTNSSVd5Yzd4c3BjdWt0OHhEVG1iZWVtcEE2VDdu?=
 =?iso-2022-jp?B?bWdjcDVncWVZZFgxTVJnM1FHV2k3LzN6dlhpbEVQR1Axc2RZSDVkYXJ5?=
 =?iso-2022-jp?B?V0I5L3NMVU9BZ3cwMmdTWHNCTzFiTy9YbnZrdk9jaUJBR284dWdoczl4?=
 =?iso-2022-jp?B?K3hWeTNtZmpxYi93NDFaeld6eENoS2hMSVZjQTgvVFVtU1AvNkFiblAw?=
 =?iso-2022-jp?B?dW1KQW45b2hidDNwZE9oanJ3ekdnWk9NOUJmQWUxTjNjYi8yd1QwL3hD?=
 =?iso-2022-jp?B?UUs5MVp4MXdNUmlhdFpJSTdQbFRGVHptT1ZFbXVLY2JsM1pKMkJzZjlI?=
 =?iso-2022-jp?B?QUZoM0xmZlVUQXNnMUdCclYrL3RkK1pkWTNaWHVZaU1lWC9nOTNwblpt?=
 =?iso-2022-jp?B?bThKOEc0U0JIQWQ0M0pTNEhJQlNGQlhHbVlpdkdjQzhWcXdLVW1KdUta?=
 =?iso-2022-jp?B?aFMzQUM2Um81K1MvZllYV1VmbE1hZEFFc2Z4QkRlenZPenFHY3JtK3FG?=
 =?iso-2022-jp?B?b05hcWVUVFJWenF3ZzJXazBQOU9tb3pGelppZUF2cS9nTHU3cU9kbzFE?=
 =?iso-2022-jp?B?VzZiRlNSeXFOc2dqQUs2d3pEUGN0QzZZb3pOamJQcytNdUZFTGI5dDNW?=
 =?iso-2022-jp?B?RkhkODFPMHRsd1ZxTTludHBHWkhHZWhhLzJFTk9yUmR3MVRlQVdXamFU?=
 =?iso-2022-jp?B?WXYyVUdXWS9tOGdEay9zR1J3Qld6WDhlTjUyRkpSM3Q1elpVMmZsMGQw?=
 =?iso-2022-jp?B?eU1QSnEzdTc3MVQ2bEIxUGRwVlFUbHZ0L25haXVoVnQrTDNlZnN0M3E4?=
 =?iso-2022-jp?B?UllSdEl5MFllVlVRdFNyd1U2WjRzZGVGa21vRWJVWkVPV0JCY0x6bHM2?=
 =?iso-2022-jp?B?c0wvbWlpVzlLYStVYU5QZEdOdEJhK0JweVBaQ0xGYzlyWkt4enVRRFJH?=
 =?iso-2022-jp?B?dno0cS9mZERNem9tUkt4QlpvMWVFUzdUd2E4cGNMYlpLb1doU0V2OUY4?=
 =?iso-2022-jp?B?d3VZZlNqaHVUcGUvL2dqK0NrTUFlRG5RNWpsTjhJQUZ4ZlhDRWVVNVIv?=
 =?iso-2022-jp?B?QUJIdXByOXVrT2M1T2tld3BxTHZHSE5CNFIvSjBVbDdlNnloaS9QdXdy?=
 =?iso-2022-jp?B?eXAyR2FlVFpMcFdsbVQyTVRRK1JNY0UrZmUrVFlQaE5NeEJSb3pyUVNn?=
 =?iso-2022-jp?B?YStpTU54V0JsZkJNRWlGSG4vZlNXUXlzSGEyMk82RFFSZUN1QnF6NjQv?=
 =?iso-2022-jp?B?Rk1scW9iRnE2ODNZcXNjYndHbVpWejBxZWZ2NjRnemtEOU5CWjNxMzVQ?=
 =?iso-2022-jp?B?Qi8zc2VHRXlaM0gwdXl2NnNvelNCU1p6aklIMmUxOXFodE1USkliVWhW?=
 =?iso-2022-jp?B?cHpWS1pEZjN6d1ZRRlJsb0VGVmwyRlZvRmxuTXpQeFFkY25IV3ppbUZG?=
 =?iso-2022-jp?B?L2lIZW4xbnJFak1CSGdpVWNrdS93K0FlY3VnR1lyMU5uWDY2dGhOdVVz?=
 =?iso-2022-jp?B?YTRqUjd4YTBYMnl0ZFRsMEgxN3NLNDNYcUE9PQ==?=
Content-Type: text/plain; charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-ExternalHop-MessageData-0: 
	oGzfcvMHebyfwvq9Abbp63a3V/VgJVwr8W2RT/Iu/cixC9SJfEuCowizQyRu6x45UMpBwCKPDpMKTHhf0jHeVfJ6ncMKPpB+h58usQEoelc6LjFCY9A/LjrDJXsZlXN0ntjKneA7TBEYJJ6t6pQo81aJqhS0PM32qqwJOTNi9tMRVbB2m7Xr+s0ylpcMxIGKsi66TL0AOeE9eGZsO/QB5LNB85ba/qr/GJdEUOPtzKKacGqNPS2LNLXrHr6+LBfIoR88xZQuk7CXIgjajtuUJlNdW4xm/EsaN6aGG0shcb8/gd7eQVGKZ7F7/PMp1eQVh26ltLByJNcibGI7yWS2dPB9JxryZ/7VnbP+CrECxaCb5jNxRfYxCyBZw7HansyfWeJAxDyQDV/hBklpjslP5mQPrWMbFL2rwSjr8VtHWM2H1ZKSNffgpm2Ux79pnwKpTamV7tXdhCKsv97odIYlxuHuYIz94Lfwdvml1tIXFqHvz38QTvAhYv2GBHgbOlKtMPDHJc+67KFytPOWxIvTOKYHnziJL9YanKwJDNKObhK3ZilQG+aGO1P1i6HND5kw2B26Z3U19Tur297s9AKWuaO5yQCpPFYLt51gWxIyD2/azCm0lyP4I9ANYIdA84QA
X-OriginatorOrg: fujitsu.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: OSCPR01MB14966.jpnprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 cfd893f2-cefd-4a52-c2db-08dddfbd12c6
X-MS-Exchange-CrossTenant-originalarrivaltime: 20 Aug 2025 07:42:11.2962
 (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: 
 z5fnZz3ydgBCOuKRiinCjQllCkLFx14Xn9+JiJr57jW0vBRvWtAlc+bdeUfFJ1aZ6sxMH1IoeVXPI5Aa+JPJJQldf4qmSSMucq/DwXVRZlc=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: OSRPR01MB11523
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/OSCPR01MB14966EEA6534F4A07A1F1722EF533A%40OSCPR01MB14966.jpnprd01.prod.outlook.com>
Precedence: bulk

Dear Michael,

I found you've pushed 0001. Thanks!
I've considered to create patches for other branches after you said OK, but
you seemed to push all of them directly.

> This has reminded me of 1a9d80282811, where I have used a trick with
> pg_ctl to allow single-user mode executions to bypass the privileged
> account permission failure, but I don't see what we could do here as
> we should pass down commands to postgres for execution via stdin for
> IPC::Run.  We don't really have anything WIN32-specific, so skipping
> the tests on Windows sounds fine by me.

OK, thanks for the confirmation.

> One thing that you have forgotten is to update EXTRA_INSTALL to add
> test_decoding, or a make check in the module fails.  I have expanded a
> bit more the tests, as for example we have paths based on active_pid
> for temporary slots, which could matter at some point.  I have added a
> few more things with physical slots.

Oh, I didn't recognize because I usually use meson, and my CI said OK.
Good update!

> With all that in mind, I don't really see the point of 0002.  There
> was also a mention of replication origins upthread, but we don't
> really have anything specific to a shared state or a validation in
> this area AFAIK, so I don't think that test additions are worth it in
> this case.

Let me clarify your point. For now, there are no decisions to prohibit orig=
in
manipulations. 0002 only restricts to handle slots in the single-user mode.=
 Did
you say that we do not have to do tests to ensure these SQL functions are
prohibited in the mode?

(Since senior members in this thread are against to restrict, I'm planning =
to
stop working 0002 after creating a final patch for the reference purpose)

Best regards,
Hayato Kuroda
FUJITSU LIMITED