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 1sreHQ-003YPX-2r for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2024 14:06:40 +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 1sreHO-006wve-4e for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2024 14:06:39 +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 1sreHN-006wsR-Lq for pgsql-hackers@lists.postgresql.org; Fri, 20 Sep 2024 14:06:39 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sreHM-000BNM-5b for pgsql-hackers@postgresql.org; Fri, 20 Sep 2024 14:06:37 +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=KfqSxk7f3D3jbDf/HBsy8sOkt3MJTh6LQidSPsjxRFw=; b=zqZnfL6tjVXLy3fu8GoUZsuoCM MkPUPTgXOy/8oJNCdsYfl50Hh3ipn/pxGQdb0Mep/xteT8yQK6MKPRrW95Mf+WGiQNqZQxQ70UJKb u5IIypJckNQfNI37Z9GQl4r4UXfC1WPJXpaD9yvXTKJ/kZUl74FlRiN/WrxoCaQpaGR+jdKRCeQYz UDvP0fIp6PJXBnCJG2ktBBFmtPsZtPjyvcn3e5snQFHnUja6IUGGo9vzuHrOQs6dkABc4EnrMv24J ROUyl57diKOCvKymzyHGj2e2aRGQQQa1eQBwry9HKl9B0T30Mvu2X9B6MAbsdH6J9SFGdSuhbyoKO Yr/6XDKw==; Received: from syn-108-176-026-082.biz.spectrum.com ([108.176.26.82] helo=[172.24.9.49]) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sreHF-000RZv-2b; Fri, 20 Sep 2024 14:06:32 +0000 Message-ID: <0d8f3541-13f4-4194-8dca-bae881cf1a9a@postgresql.org> Date: Fri, 20 Sep 2024 10:06:28 -0400 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Should rolpassword be toastable? To: Michael Paquier , Nathan Bossart Cc: Tom Lane , Alexander Lakhin , pgsql-hackers References: <1284094.1695479962@sss.pgh.pa.us> <67793ae1-3adc-a6e0-0bb3-c23a28c0627a@gmail.com> <1986859.1726756275@sss.pgh.pa.us> <2047353.1726784074@sss.pgh.pa.us> <0a9b7f96-aa2f-41eb-8e69-62f7990ebf74@postgresql.org> 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="------------igEuyvVowhRZKbuqx37ARKCC" 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) --------------igEuyvVowhRZKbuqx37ARKCC Content-Type: multipart/mixed; boundary="------------SHoS0Yvp07x1gBzhR3KHIkLJ"; protected-headers="v1" From: "Jonathan S. Katz" To: Michael Paquier , Nathan Bossart Cc: Tom Lane , Alexander Lakhin , pgsql-hackers Message-ID: <0d8f3541-13f4-4194-8dca-bae881cf1a9a@postgresql.org> Subject: Re: Should rolpassword be toastable? References: <1284094.1695479962@sss.pgh.pa.us> <67793ae1-3adc-a6e0-0bb3-c23a28c0627a@gmail.com> <1986859.1726756275@sss.pgh.pa.us> <2047353.1726784074@sss.pgh.pa.us> <0a9b7f96-aa2f-41eb-8e69-62f7990ebf74@postgresql.org> In-Reply-To: --------------SHoS0Yvp07x1gBzhR3KHIkLJ Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gOS8yMC8yNCAxOjIzIEFNLCBNaWNoYWVsIFBhcXVpZXIgd3JvdGU6DQo+IE9uIFRodSwg U2VwIDE5LCAyMDI0IGF0IDA5OjQ2OjAwUE0gLTA1MDAsIE5hdGhhbiBCb3NzYXJ0IHdyb3Rl Og0KPj4gT24gVGh1LCBTZXAgMTksIDIwMjQgYXQgMDc6Mzc6NTVQTSAtMDQwMCwgSm9uYXRo YW4gUy4gS2F0eiB3cm90ZToNCj4+Pj4gU2hvdWxkbid0IHdlIGVuZm9yY2UgdGhlIGxpbWl0 IGluIGV2ZXJ5IGNhc2UgaW4gZW5jcnlwdF9wYXNzd29yZCwNCj4+Pj4gbm90IGp1c3QgdGhp cyBvbmU/ICAoSSBkbyBhZ3JlZSB0aGF0IGVuY3J5cHRfcGFzc3dvcmQgaXMgYW4gb2theQ0K Pj4+PiBwbGFjZSB0byBlbmZvcmNlIGl0LikNCj4+DQo+PiBZZWFoLCB0aGF0IHNlZW1zIGxp a2UgYSBnb29kIGlkZWEuICBJJ3ZlIGF0dGFjaGVkIGEgbW9yZSBmbGVzaGVkLW91dCBwYXRj aA0KPj4gc2V0IHRoYXQgYXBwbGllcyB0aGUgbGltaXQgaW4gYWxsIGNhc2VzLg0KPiANCj4g Tm90IHN1cmUuICBJcyB0aGlzIHJlYWxseSBzb21ldGhpbmcgd2UgYWJzb2x1dGVseSBuZWVk PyAgU3VyZSwgdGhpcw0KPiBnZW5lcmF0ZXMgYSBiZXR0ZXIgZXJyb3Igd2hlbiBpbnNlcnRp bmcgYSByZWNvcmQgdG9vIGxvbmcgdG8NCj4gcGdfYXV0aGlkLCBidXQgcmVtb3ZpbmcgdGhl IHRvYXN0IHJlbGF0aW9uIGlzIGVub3VnaCB0byBhdm9pZCB0aGUNCj4gcHJvYmxlbXMgb25l IHdvdWxkIHNlZSB3aGVuIGF1dGhlbnRpY2F0aW5nLiAgTm90IHN1cmUgaWYgdGhpcyBhcmd1 bWVudA0KPiBpcyBlbm91Z2ggdG8gY291bnQgYXMgYW4gb2JqZWN0aW9uLCBqdXN0IHNoYXJp bmcgc29tZSBkb3VidHMgOikNCg0KVGhlIGVycm9ycyBmcm9tIGxhY2sgb2YgVE9BU1QgYXJl IGNvbmZ1c2luZyB0byB1c2Vycy4gV2h5IGNhbid0IHdlIGhhdmUgDQphIHVzZXIgZnJpZW5k bHkgZXJyb3IgaGVyZT8NCg0KSm9uYXRoYW4NCg== --------------SHoS0Yvp07x1gBzhR3KHIkLJ-- --------------igEuyvVowhRZKbuqx37ARKCC 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/x8QSccp8cZScFAmbtgWQFAwAAAAAACgkQ8QSccp8cZScR dw//aMkqltNdjA0yo8xKdcV9IHfjiSbKg0FPTMPhHRRtGJzb/Pcvihm+GnPaISkVofZbzxykdEV+ LR7fa0J9+FTRfEEytb5sIt7Zzyf0rKCDBiCReTV+12i3TuvuzbF2h7zJhVOSY4uqtAE0r+LVM8DM Z935oNuIshzS5hMcdgcJ1agmwiOisR2XBz9mwoAZyC38IUHi2vsu2H6OOf4l/PzCAionV2xPlNzp xdYO4HsR4Fw9ZV6g7R40iqGT3uoxPzs816zcHXs3vJxbTgWWlI4LPVFo0BOxVBeFoz6fI6/iVTlu ZHPFgTAiNERhVCM6aJ0Zo/4GxbZm4qI6Y92h8gswcFoHM2/LiC8+AzdnVmXK77YqCtzOT0z4UgMC j1YZ6V/S7Ru8IIgjPNrUgW3w0yrHa+L+IWQ/K5QmlmZAtRrurJboUG2RZSInl38sTdBr2JHOf75U 5/IoGU2lyNzQrJiC3tLXKKADZXqhthuUjsog9cJR51totWFEfgNSaGO37yRy/fv1AuvgDzGxzrWF LfoypAnoAcjrYPCP8/J6OyE4CsTpED1ZePrhZwL0maD2L4uI3jQnsTGMg9ObL0DF4zWLS5bzIfUB r7rKPZK4hwKFMFOSMUdtxbln+AMMeO0gXbXI52k3kzBmg+mtEjYAAMKtwHNDw8PcgdQppo+zQL7T SgI= =Um4l -----END PGP SIGNATURE----- --------------igEuyvVowhRZKbuqx37ARKCC--