Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nP9sQ-0004ak-Kq for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Mar 2022 21:17:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nP9sP-000140-Gz for pgsql-hackers@arkaria.postgresql.org; Tue, 01 Mar 2022 21:17:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nP9sP-00013g-1y for pgsql-hackers@lists.postgresql.org; Tue, 01 Mar 2022 21:17:45 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nP9sM-0000tQ-Kc for pgsql-hackers@lists.postgresql.org; Tue, 01 Mar 2022 21:17:44 +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:Subject:From: References:Cc:To:MIME-Version:Date:Message-ID:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description; bh=tD5S80p5CNfLUhJxWmY8Ov5Y5mBcauQfZq1vu5ZI8sQ=; b=4+sAJQTrHA5VP731+/cB6aC4vN hzbSZi3UTohkqpnYFdDpcF9idHudRjVsKaz17vKK9I+8JRgQjtsz5qzt3lBg34XwYqAUIo6PWxesv 3plkyuRxSp2bEL7IirTDGmx63SU7QxilEazzTo2wcyUZhLiheaXCDs8thozerH+h3HpBtSavOGYHy jTZCo/X/p5vhHxKQ/TgFsAkdBt2q9NbTg5IddUd2lYPg38mrwQCQOsARoA3oiLgfbpAHtY6IGsV41 g6FmkSRX17p4C3cIQceKUmGdr3EFzMAY+opAWdO29C4g4ddNdJ5Wk9rC9Cnn8Jg0zK6Yzy2yZV1ny PQey86qw==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nP9sC-0006at-Uk; Tue, 01 Mar 2022 21:17:35 +0000 Message-ID: <5de09fc4-8feb-8a91-d74a-fc9682208337@postgresql.org> Date: Tue, 1 Mar 2022 16:17:28 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.6.1 Content-Language: en-US To: Stephen Frost , Michael Paquier Cc: Tom Lane , Jeff Davis , samay sharma , pgsql-hackers@lists.postgresql.org References: <1737574.1645753674@sss.pgh.pa.us> <54dc198b56a87e31e9625405383f04a8c6589b8b.camel@j-davis.com> <1905579.1645810764@sss.pgh.pa.us> <2718414dc095b716e59e126c03af343997d14c7b.camel@j-davis.com> <1980351.1645816239@sss.pgh.pa.us> <9004b18218eae293f1ee888e49d13d8a6b02810d.camel@j-davis.com> <20220228204634.GM10577@tamriel.snowman.net> <2738622.1646083128@sss.pgh.pa.us> <20220228214255.GO10577@tamriel.snowman.net> <20220301133119.GR10577@tamriel.snowman.net> From: "Jonathan S. Katz" Subject: Re: Proposal: Support custom authentication methods using hooks In-Reply-To: <20220301133119.GR10577@tamriel.snowman.net> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------y1Neo05qDpE31mjk4XKsERT0" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (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) --------------y1Neo05qDpE31mjk4XKsERT0 Content-Type: multipart/mixed; boundary="------------QjGBJ0NrGyPQZh25wllk6Err"; protected-headers="v1" From: "Jonathan S. Katz" To: Stephen Frost , Michael Paquier Cc: Tom Lane , Jeff Davis , samay sharma , pgsql-hackers@lists.postgresql.org Message-ID: <5de09fc4-8feb-8a91-d74a-fc9682208337@postgresql.org> Subject: Re: Proposal: Support custom authentication methods using hooks References: <1737574.1645753674@sss.pgh.pa.us> <54dc198b56a87e31e9625405383f04a8c6589b8b.camel@j-davis.com> <1905579.1645810764@sss.pgh.pa.us> <2718414dc095b716e59e126c03af343997d14c7b.camel@j-davis.com> <1980351.1645816239@sss.pgh.pa.us> <9004b18218eae293f1ee888e49d13d8a6b02810d.camel@j-davis.com> <20220228204634.GM10577@tamriel.snowman.net> <2738622.1646083128@sss.pgh.pa.us> <20220228214255.GO10577@tamriel.snowman.net> <20220301133119.GR10577@tamriel.snowman.net> In-Reply-To: <20220301133119.GR10577@tamriel.snowman.net> --------------QjGBJ0NrGyPQZh25wllk6Err Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 T24gMy8xLzIyIDg6MzEgQU0sIFN0ZXBoZW4gRnJvc3Qgd3JvdGU6DQo+IEdyZWV0aW5ncywN Cj4gDQo+ICogTWljaGFlbCBQYXF1aWVyIChtaWNoYWVsQHBhcXVpZXIueHl6KSB3cm90ZToN Cj4+IE9uIE1vbiwgRmViIDI4LCAyMDIyIGF0IDA0OjQyOjU1UE0gLTA1MDAsIFN0ZXBoZW4g RnJvc3Qgd3JvdGU6DQo+Pj4gS2VlcGluZyBpdCBhcm91bmQgd2lsbCBqdXN0IHB1c2ggb3V0 IHRoZSBwb2ludCBhdCB3aGljaCBldmVyeW9uZSB3aWxsDQo+Pj4gZmluYWxseSBiZSBkb25l IHdpdGggaXQsIGFzIHRoZXJlJ3MgcmVhbGx5IG9ubHkgdHdvIGdyb3VwczogdGhvc2Ugd2hv DQo+Pj4gaGF2ZSBhbHJlYWR5IG1vdmVkIHRvIHNjcmFtLCBhbmQgdGhvc2Ugd2hvIHdvbid0 IG1vdmUgdW50aWwgdGhleSB3YW50IHRvDQo+Pj4gdXBncmFkZSB0byBhIHJlbGVhc2UgdGhh dCBkb2Vzbid0IGhhdmUgbWQ1Lg0KPj4NCj4+IEZXSVcsIEkgYW0gbm90IHN1cmUgaWYgd2Ug YXJlIGF0IHRoaXMgcG9pbnQgeWV0LiAgQW4gZXh0cmEgcmVhc29uIHRvDQo+PiByZW1vdmUg aXQgd291bGQgYmUgdGhhdCBpdCBpcyBhIHN1cHBvcnQgYnVyZGVuLCBidXQgSSBkb24ndCBo YXZlIHNlZW4NCj4+IGluIHJlY2VudCBtZW1vcnkgYW55IHByb2JsZW1zIHJlbGF0ZWQgdG8g aXQgdGhhdCByZXF1aXJlZCBhbnkgZGVlcA0KPj4gY2hhbmdlcyBpbiB0aGUgd2F5IHRvIHVz ZSBpdCwgYW5kIGl0cyBjb2RlIHBhdGhzIGFyZSBpbmRlcGVuZGVudC4NCj4gDQo+IE9uZ29p bmcgcmVwb3J0cyB0aGF0IHRoZXJlJ3MgYSBrbm93biB2dWxuZXJhYmlsaXR5IGFyZW4ndCBn cmVhdCB0byBoYXZlDQo+IHRvIGRlYWwgd2l0aC4gIFdlIGNhbiBhdCBsZWFzdCBwb2ludCBw ZW9wbGUgdG8gc2NyYW0gYnV0IHRoYXQncyBub3QNCj4gZ3JlYXQuDQo+IA0KPj4gVGhlIGxh c3QgdGltZSBJIHBsYXllZCB3aXRoIHRoaXMgYXJlYSBpcyB0aGUgcmVjZW50IGVycm9yIGhh bmRsaW5nDQo+PiBpbXByb3ZlbWVudCB3aXRoIGNyeXB0b2hhc2hlcyBidXQgTUQ1IGhhcyBh Y3R1YWxseSBoZWxwZWQgaGVyZSBpbg0KPj4gZGV0ZWN0aW5nIHRoZSBwcm9ibGVtIGFzIGEg cGF0Y2hlZCBPcGVuU1NMIHdvdWxkIGNvbXBsYWluIGlmIHRyeWluZyB0bw0KPj4gdXNlIE1E NSBhcyBoYXNoIGZ1bmN0aW9uIHdoZW4gRklQUyBpcyBlbmFibGVkLg0KPiANCj4gSGF2aW5n IHRvIGNvbnRpbnVlIHRvIGRlYWwgd2l0aCBtZDUgYXMgYW4gYWxnb3JpdGhtIHdoZW4gaXQn cyBrbm93biB0bw0KPiBiZSBub3RhYmx5IGxlc3Mgc2VjdXJlIGFuZCBzbyBtdWNoIHNvIHRo YXQgb3JnYW5pemF0aW9ucyBlc3NlbnRpYWxseSBiYW4NCj4gaXRzIHVzZSBmb3IgZXhhY3Rs eSB3aGF0IHdlJ3JlIHVzaW5nIGl0IGZvciwgaW4gZmFjdCwgYW5vdGhlciByZWFzb24gdG8N Cj4gcmVtb3ZlIGl0LCBub3QgYSByZWFzb24gdG8ga2VlcCBpdC4gIEJldHRlciBjb2RlIGNv dmVyYWdlIHRlc3Rpbmcgb2YNCj4gZXJyb3IgcGF0aHMgaXMgdGhlIGFuc3dlciB0byBtYWtp bmcgc3VyZSB0aGF0IG91ciBlcnJvciBoYW5kbGluZyBiZWhhdmVzDQo+IHByb3Blcmx5Lg0K DQpTbywgSSBnZW5lcmFsbHkgYWdyZWUgd2l0aCBTdGVwaGVuIGFuZCBoaXMgYXJndW1lbnRz IGZvciBkcm9wcGluZyB0aGUgDQptZDUgbWVjaGFuaXNtLg0KDQpJZiB5b3UncmUgbW92aW5n IHRvIGEgbmV3ZXIgdmVyc2lvbiBvZiBQb3N0Z3JlU1FMLCB5b3UgbGlrZWx5IGhhdmUgdG8g DQp1cGRhdGUgeW91ciBjb25uZWN0aW9uIGRyaXZlcnMgYW55d2F5IChyZWJ1aWx0IGFnYWlu c3QgbmV3IGxpYnBxLCANCnN1cHBvcnRpbmcgYW55IGNoYW5nZXMgaW4gdGhlIHByb3RvY29s LCBldGMpLiBJIHdvdWxkIHByZWZlciBtb3JlIGRhdGEgDQp0byBzdXBwb3J0IHRoYXQgYXJn dW1lbnQsIGJ1dCB0aGlzIGlzIGdlbmVyYWxseSB3aGF0IHlvdSBuZWVkIHRvIGRvLg0KDQpI b3dldmVyLCB3ZSBtYXkgbmVlZCB0byBzdGVwIHRvd2FyZHMgaXQuIFdlIHRvb2sgb25lIHN0 ZXAgbGFzdCByZWxlYXNlIA0Kd2l0aCBkZWZhdWx0aW5nIHRvIFNDUkFNLiBQZXJoYXBzIHRo aXMgcmVsZWFzZSB3ZSBhZGQgYSB3YXJuaW5nIGZvciANCmFueXRoaW5nIHVzaW5nIG1kNSBh dXRoIHRoYXQgInRoaXMgd2lsbCBiZSByZW1vdmVkIGluIGEgZnV0dXJlIHJlbGVhc2UuIiAN CihvciBzcGVjaWZpY2FsbHkgdjE2KS4gV2Ugc2hvdWxkIGFsc28gaW5kaWNhdGUgaW4gdGhl IGRvY3MgdGhhdCBtZDUgaXMgDQpkZXByZWNhdGVkIGFuZCB3aWxsIGJlIHJlbW92ZWQuDQoN CldlIGFsc28gbmVlZCB0byB0aGluayBhYm91dCB1cGdyYWRpbmc6IHdoYXQgaGFwcGVucyBp ZiBJIHRyeSB0byB1cGdyYWRlIA0KYW5kIEkgc3RpbGwgaGF2ZSB1c2VyIHBhc3N3b3JkcyBz dG9yZWQgaW4gYSBtZDUgaGFzaD8gV2hhdCBpZiBhbGwgbXkgDQpwYXNzd29yZC1iYXNlZCB1 c2VycyBoYXZlIGEgbWQ1IGhhc2gsIGRvZXMgcGdfdXBncmFkZSBmYWlsPw0KDQpBcyBtdWNo IGFzIEkgd2FudCBtZDUgZ29uZSwgSSB0aGluayB2MTYgaXMgdGhlIGVhcmxpZXN0IHdlIGNh biBkbyBpdCwgDQpidXQgd2UgY2FuIGxheSB0aGUgZ3JvdW5kd29yayBmb3IgaXQgbm93Lg0K DQpUaGFua3MsDQoNCkpvbmF0aGFuDQo= --------------QjGBJ0NrGyPQZh25wllk6Err-- --------------y1Neo05qDpE31mjk4XKsERT0 Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmIejWgFAwAAAAAACgkQ8QSccp8cZSdN xA//QTP7TpbLDBMs36h7B+ZGAjU943/W6KFkjtUemEudnOLDIdf7G97CQpDk/tu7FwGK5PRCQbzL KIWGzc2RnqUK8R+nqb2SJ2N6xr6fkhWZNfQv4UcHWpqDcIGIAT+6XcJODeIT4mUjd6ljzr+ejOo5 aqVKuHQFyZFfaLQ1nCNTppQzVU/XOXSb7NsWOWgmWiMAd/6xTk22z4qvvl5hIPzWfbSmYheIWzsB 29+HnIkW0QQxakf5Bqphy246n4h46zgWelB8hNRCNlw1LN7VNBjf294sVjiQL33VN5SLnyWGnpof A+q/FPRR/Jat0720aVefhJupui1b+ZKl3dR6iZYpn9vzXT4JoTl9sB/LSnPF4vEXdqeFAxKI6LQc mF5e3wJjbOcU7VUsUDGXGw62syoYj2Ikm0bop8Rbt8FlrBuF/oBJv4ARc7rObZ9E/hpdAso7kNjO L5K2Oo8zKqE5eN/8/InQ/UZZhNKxvfmTJnoRn8wGiGeKjFgpNH5CmKk5OEh7WG7JqkUHv/QGVOJW MFSYaJsrSCf2Ww5ZEo8dzhdcKfySJ8vkkZHE/Pb6MmY9FMi/y+2Y1rMlHRqTTFAn6WbAqG0K3513 h4GU9SH8mKKK5rdHy27QSPqwAfA8pqvb9o0sFky+wJ6rsj/hd2ANPiyhFKHvF4xb0m67jXjjdcxh DUA= =R+zm -----END PGP SIGNATURE----- --------------y1Neo05qDpE31mjk4XKsERT0--