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 1swXt7-004R7F-IK for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Oct 2024 02:17:50 +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 1swXt5-008Ct4-OQ for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Oct 2024 02:17:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1swXt4-008Csw-SL for pgsql-hackers@lists.postgresql.org; Fri, 04 Oct 2024 02:17:47 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1swXt0-002RHR-Jn for pgsql-hackers@postgresql.org; Fri, 04 Oct 2024 02:17:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:From:References:Cc: To:Subject:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=usfc9r9GAA/XGJxBacmFuiLOtUIPBreEG9nICQ80rZo=; b=sCDN1BIcqURb5en18RXlVaBHt/ KC1s32xweflaRDk8UnVfTX74vj0wfmpDbMiGQGu1dDaBzTy7H8fLfoxzUe/1cjU37/PteMPW6yRI/ maBi19ZSUcc6mXHNCYH7syT78C3LoouKDusP4R8A1XMsFjxsDLxEsKFqj4hgG5+YfWtWTQALfNH4R XEp20ezpVQQ8G/vc055ckXm231AQqGK4gW0CdJOe5ly0Qa3UdIpI95k0DUAsyVov6eOvOeWEtZWsR jDQ8/EZYfq92el5Svl1UMtuZPLI+HZglzbjZnztTNjnLkgM6C4FM7Evs4mDCbO4opGPls5/vm+PZr xN9L34nA==; Received: from [52.119.84.39] (helo=[192.168.88.172]) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1swXsr-006PD4-VF; Fri, 04 Oct 2024 02:17:37 +0000 Message-ID: Date: Thu, 3 Oct 2024 22:17:31 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Should rolpassword be toastable? To: Jacob Champion , Tom Lane Cc: Nathan Bossart , Michael Paquier , Alexander Lakhin , pgsql-hackers References: <2047353.1726784074@sss.pgh.pa.us> <0a9b7f96-aa2f-41eb-8e69-62f7990ebf74@postgresql.org> <0d8f3541-13f4-4194-8dca-bae881cf1a9a@postgresql.org> <2445149.1726849661@sss.pgh.pa.us> <465160.1727991546@sss.pgh.pa.us> <473657.1727994294@sss.pgh.pa.us> Content-Language: en-US From: "Jonathan S. Katz" Autocrypt: addr=jkatz@postgresql.org; keydata= xsFNBFtShwABEAC7PNHDUOTYuifpUCk23KqfxdQQkn4nkoxOXRK0+rAj36FiwqGB4TJFuOVZ sDFAEiSlC8Jt4y5Cs7B5tetT8JNd2cs6zp/udMJJDz9d65O9PDpdlMgAmIiTzpLlSdx8FG56 DTksaDv1d8j3cTJPSE4/fWSxqzA7o3Y9UuL7atZPrzfImgpRKs0of7elIHwOa8GucjyhYqcR h60wFBJc2KXqQdDYRTZy43DSnY/0VNc0omiH355fustvpm+m5HjD3w7qZyfN3fpKJpnX1LCF f3MnPHaDGITIYGRCBXvf0UqUtD6OEVWPv2C2gyqWMIpWmZTOgDufltKyIByKBoS9x0PlFkij 04X3KODCngt+N8Ssc9OICc6QSxhjoP48PYPdmiTmkrGuf0LX084wj1xeo1NX7XxZK39F6dTJ DhsIiW0sNS0xMxQHLHG9VLbPjx3SANQBh6BuryPz5ZupW9/TIDmkvprtU/oXfKgtfYm3fxmk EctxbWrEPsFTFPyuMqQu6l+xyQv0s1VLZfjNWaua6H1/gGoIt6kRnn5qMXDVVpijuWkHbv7G ngaQMd258UrrOEHnnjzhQ7jxMWV9D+emxbAtlIxnYvCWlV4IwAQhEHfvudqYaIY3hNWrvQ6H GB2KXoTZYN9g5djm14/5nj1IU5zOcovkjJnKhoo9iStnpFF2cwARAQABzSdKb25hdGhhbiBT LiBLYXR6IDxqa2F0ekBwb3N0Z3Jlc3FsLm9yZz7CwY4EEwEIADgCGwMFCwkIBwIGFQoJCAsC BBYCAwECHgECF4AWIQT6hLaVryv3miBkP/HxBJxynxxlJwUCYvBxpgAKCRDxBJxynxxlJ/Us EACe5W9aBAJGdFjbHc+yEy/0UVcDhDeNeJC8vGuyuMwj6cZgm8HmVddaGKWaumaDziOnGj5B zBUB9cZBPuM+j8Gli2F5hdSTeLZseHqNtuj2sGpTaZ+6utCt3iMIh+ZrHq2ufqMj9m6uA93+ SziFGcA+8+qKFTjqTUgZUxEgLnInk9191NaQT/LiH34JRlFY009XIQWRfDBYB8kJHpDQbp9y 9gsyzgYEMO4bxsXgD4BeHKW+s9OmP/zlDyHOLtyrsXLZHZA42TR/tnSTTwC9Xcx99eh5AS+u t1orACYzZfTEWph2of8AI0cuAT3c3MZNw7ypLcejr/Y71wAXQeiC55ZKrx6rsmsICXohx8be l0Lsnm+oHqSzfbVxZe/2teHLfaupD4P1OPnM9ljeqvIyhvHFlrc6LUHzMv0jf97TUCcWmmo9 qWmzT8wFkSDbFMj5Vk0hJ/nexipTqTzWQo5G9yN6aUDiOBDTvWeMGAvso01/11M/Tf7Ouq/S kcHFhpZgm7EzakFrmMD1l0DsyXUM4AtErvEC/4M5ZMNvwmvXUC3ndrSv00k3wrtQ2t9OGT4h NciB7uqiU+DrxoEZHx+AUC0MhKE96E3KQ+XYjUHfVr+ribl/2oiwazdCjVrkVyKoyMs5IQ1X gaOhxsLp2uBCdzQqMOmGxplc+K03KhJZ6TiU9s7BTQRbUocAARAAv8ho/toQ9DG3j4f9h9n1 aRHr2FlviN2Utpy6L8+dfDggO0geilmkGQOolZ2E60gGfye/kUtF9W3NByO4hxDR9u6qbOXc dqnuA+cc68EfqlWFJrVtYFxt0h4ElWYOYnIezKthriWch/FY70FGrxs3z8UHOHq50wBW433e TvZm90WixBiXEt2v1DgW4Vr3ymfO7Aap/IYyPuE4JzgudAuAl0HKPyNEHWHG1dAbjX1RiCw9 gknIDWQOF0B4UAaJctWGVcnZ3A2ULwNGMa1P9ZJlBWf1vcj01aiHMU0yQ7JjJiSpvfm9eM0u SLwRdDrJjyl5ZZqVumjdv2SMNQ8GvYRbEMys3GGDSt9zXgfCSUnPnJfYxjzBHRI6x44Wfsx8 S6hWxepOogCJJ/g67Bk9mY8YV4klWIXDJVOL5jnBC09DbsZG81JaE2QxB8Y7W36ZMroi9XMx g3s805hQAQUvdG/poU8hN8BWdrnTm/+4eQQp7gDY1ePDmGM6bJC+OHOSnFtR/f+70zpKJ10c c7cBygGnl1yR3KjhFyAWUFvP4ZGziKCcpMwXZfe9PGuyA/YOubMphxIn3YsK2wrdfaKZYX2G MZCZhMMcvx9IpQrxIJgU+VlwXu/O+Lk10VIPcxPJJwmpdI6HzcS8ZgG6IMcC444XXTuLaP8j 2mgcMvYak3ScCykAEQEAAcLBdgQYAQgAIBYhBPqEtpWvK/eaIGQ/8fEEnHKfHGUnBQJi8HGn AhsMAAoJEPEEnHKfHGUneVcQALCswm06CgJjQ+lFmjYaw/OFZ9LJgHbaqGrfyNmjIXOhRiqt 65VWmC8/yetWCfLtXzCsPrQGXjon1IuKZUfcvVQ39lh8apvfUweNWH9xCpHkWmai8rKbjTkd 0YXyK9dYVPw7ATKSpMzM61QvPIndjQ7iTT1SnCINj7zMDuMSuyiTUGr57VmXzFW466BJ/XGg P5+mLYrbjpbsB0ByUbral6XBs57LYSRFzQ17SekWlAlFSlW6xTCdKq7VKYd+Utb8N7uXejNG qjDCXmcPB45+pYC9ckSKyWceFpSqjO7OzMK8Q1OfGIAuQQ3UegGefuhIV06mWXsrgLOGSbM8 ZH9GT1OxkFiDneSSCmjHRzTWgPSH7c/9r5cG5Uo5GIfVDIgirhcgKwUgullb2r3vZDBRKi9N 44NeTkaE7KdfEkziDhe96OMdrCLnH4Kt2Gcgc4R/sibjqtvxX/YvmaiimK1H6fa74sstqSlZ w8Jbr9hQvk0P4UzySrlmsuOGwHodeM8R/Tklke6AJkYANcyP4r8xRfAe/pTH7zz4usdlncgP Z/WieSo1zvU6VEh6TAwakocfUDIcpqSxcZAs2pfjjNz+owqoFWMbn6BEO0J0xX65p//J9vd3 LZLjN6yBvXCRDoSD+B85thpxQSoI+jXC8d7DiejNLaHqxkgUeyfq9n99cyl3 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------f3tRvZErd4qq0n82WdidHZQY" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.39 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------f3tRvZErd4qq0n82WdidHZQY Content-Type: multipart/mixed; boundary="------------tw77jfwn9kVwP91hj06smwX0"; protected-headers="v1" From: "Jonathan S. Katz" To: Jacob Champion , Tom Lane Cc: Nathan Bossart , Michael Paquier , Alexander Lakhin , pgsql-hackers Message-ID: Subject: Re: Should rolpassword be toastable? References: <2047353.1726784074@sss.pgh.pa.us> <0a9b7f96-aa2f-41eb-8e69-62f7990ebf74@postgresql.org> <0d8f3541-13f4-4194-8dca-bae881cf1a9a@postgresql.org> <2445149.1726849661@sss.pgh.pa.us> <465160.1727991546@sss.pgh.pa.us> <473657.1727994294@sss.pgh.pa.us> In-Reply-To: --------------tw77jfwn9kVwP91hj06smwX0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gMTAvMy8yNCA3OjI5IFBNLCBKYWNvYiBDaGFtcGlvbiB3cm90ZToNCj4gT24gVGh1LCBP Y3QgMywgMjAyNCBhdCAzOjI14oCvUE0gVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPiB3 cm90ZToNCj4+DQo+PiBOYXRoYW4gQm9zc2FydCA8bmF0aGFuZGJvc3NhcnRAZ21haWwuY29t PiB3cml0ZXM6DQo+Pj4gSSBkb24ndCBtaW5kIHByb2NlZWRpbmcgd2l0aCB0aGUgcGF0Y2gg aWYgdGhlcmUgaXMgc3Ryb25nIHN1cHBvcnQgZm9yIGl0Lg0KPj4+IEkgd2F2ZXJlZCBvbmx5 IGJlY2F1c2UgaXQncyBoYXJkIHRvIGJlIGNvbmZpZGVudCB0aGF0IHdlIGFyZSBjaG9vc2lu ZyB0aGUNCj4+PiByaWdodCBsaW1pdC4NCj4+DQo+PiBJJ20gbm90IHRoYXQgZnVzc2VkIGFi b3V0IGl0OyBzdXJlbHkgMjU2IGlzIG1vcmUgdGhhbiBhbnlvbmUgaXMgdXNpbmc/DQo+PiBJ ZiBub3QsIHdlJ2xsIGdldCBwdXNoLWJhY2sgYW5kIHRoZW4gd2UgY2FuIGhhdmUgYSBkaXNj dXNzaW9uIGFib3V0IHRoZQ0KPj4gY29ycmVjdCBsaW1pdCB0aGF0J3MgaW5mb3JtZWQgYnkg bW9yZSB0aGFuIGd1ZXNzd29yay4NCj4gDQo+ICsxLg0KPiANCj4gTmV4dCB1cCBpcyBwcm9i YWJseSBTQ1JBTS1TSEEtNTEyLCB3aGljaCBzaG91bGQgc3RpbGwgaGF2ZSBzbWFsbGVyDQo+ IGVudHJpZXMgdGhhbiB0aGF0IC0tIDIyMiBieXRlcywgSSB0aGluaywgd2l0aCAxMjgtYml0 IHNhbHRzIGFuZCBhDQo+IDUtZGlnaXQgaXRlcmF0aW9uIGNvdW50Pw0KDQpUaGUgY2hhbGxl bmdlIGlzIHRoYXQgc2FsdHMgY2FuIGJlIGFuIGFyYml0cmFyeSBsZW5ndGgsIGV2ZW4gdG9k YXkgKGFzIA0KY2FuIHRoZSBpdGVyYXRvciB2YWx1ZSwgdGhvdWdoIElJUkMgSSB0aGluayB3 ZSBjaGVjayBpZiBpdCdzIGluIGludCANCmJvdW5kcywgYW5kIGEgbGFyZ2UgaXRlcmF0b3Ig YmVjb21lcyBwcmV0dHkgaW1wcmFjdGljYWwgZm9yIHVzYWdlKS4NCg0KUHJvYmFiYWxpc3Rp Y2FsbHksIGl0J3MgdW5saWtlbHkgdGhlcmUgYXJlIG1hbnkgdmVyeSBsYXJnZSBzYWx0cyBp biB0aGUgDQp3aWxkICh0aG91Z2ggSSBkb24ndCBoYXZlIGRhdGEgb24gdGhhdCkgYW5kIG1v c3QgZm9sa3MgYXJlIHVzaW5nIHRoZSANCmRlZmF1bHQgbGVuZ3RoLCBidXQgdGhhdCBwcm9i YWJpbGl0eSBpc24ndCAwLg0KDQpJIHRoaW5rIFRvbSdzIGluaXRpYWwgc3VnZ2VzdGlvbiAo QkxDS1NaLzIpIGlzIGJldHRlciB0aGFuIDI1NiwgZ2l2ZW4gd2UgDQpyZWFsbHkgZG9uJ3Qg a25vdyB3aGF0JyBvdXQgdGhlcmUgaW4gdGhlIHdpbGQsIGFuZCB0aGlzIGNvdWxkIGVuZCB1 cCANCmJlaW5nIGEgYnJlYWtpbmcgY2hhbmdlLiBFdmVyeSBvdGhlciB0eXBlIGluIHBnX2F1 dGhpZCBpcyBwcmV0dHkgc21hbGwuIA0KVGhhdCBzYWlkLCBJJ20gYWxzbyBpbWFnaW5pbmcg b3RoZXIgdGhpbmdzIHdlIG1heSBhZGQgdGhhdCBjb3VsZCByZXF1aXJlIA0KVE9BU1Qgc3Vw cG9ydCAocmVtZW1iZXJpbmcgcHJldmlvdXMgcGFzc3dvcmRzPyBzdG9yaW5nIG11bHRpcGxl IA0KcGFzc3dvcmRzIG9wdGlvbnMpPw0KDQpUaGFua3MsDQoNCkpvbmF0aGFuDQo= --------------tw77jfwn9kVwP91hj06smwX0-- --------------f3tRvZErd4qq0n82WdidHZQY Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature.asc" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmb/UDsFAwAAAAAACgkQ8QSccp8cZSdP DRAAiD2D32LmdrNQBJ2O5bDxJO2Wk9bil22QbO5NNJtGIJkZ+a26ASWNGn6aZkl0000EAHzITM1z oSZNuns6f3mANX00HmJU+RdEzM/V6EqYVphVCTQVdd+ohT/Adpjv3pRaVVqe9qJY010wm48ki/bG 0aldDpcZlx8EHL3qRAJwCmRHYAKoa1xGI2sc8TNjd/s+FTFxA4C/KeJSf1YbNa8+Ku34uRTWetAV 0jzrfSBNdiGOz03cFgxItob7HXcexpFJEL+6sTPZcBYkhR7NUl5TouOBKxZj9yXAGR5MaArRL43e 6j3A27km7I/mrEjSbdHMcSnIFLv78YHBsw5nCedShKlEQSS6ow/V9wrlKHYCZqttlO0iztUvLCLr jH5O5Eb3gysN9tFIsjL6paxiJufnmYMuRfumNteVLciDW/DaczXu0wZ+EBP7a5ujNuad0GMEOH5N lCt9pCBe5yjXwih1UX4+kYWdMV3tCVycFiSQ+X5vBU5FtUnHvIACA5CdyyIu+8ZmW3YnxMERPvNw L1s76tRDo1SarVf77+ImGRomL6iimophhMGQcKc3fxMFVf9qRiQrZWQ4IrydyI1KP70fl8u2nQsF uXvRx2E528AjzQ7ZCNOdVEeUN5VM82puKadkdLEiT0Fbd4h29qu2lQ2aH/APi7169xU4kGEYkdTS aas= =21pF -----END PGP SIGNATURE----- --------------f3tRvZErd4qq0n82WdidHZQY--