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 1sAb0T-00B0KV-O4 for pgsql-hackers@arkaria.postgresql.org; Fri, 24 May 2024 19:55:15 +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 1sAb0R-008t1h-5L for pgsql-hackers@arkaria.postgresql.org; Fri, 24 May 2024 19:55:11 +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 1sAb0Q-008t1Z-Rd for pgsql-hackers@lists.postgresql.org; Fri, 24 May 2024 19:55:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sAb0M-000ajI-Fj for pgsql-hackers@lists.postgresql.org; Fri, 24 May 2024 19:55:10 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sAb0K-005kdQ-J2 for pgsql-hackers@lists.postgresql.org; Fri, 24 May 2024 19:55:04 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sAb0J-0044Ej-De for pgsql-hackers@lists.postgresql.org; Fri, 24 May 2024 19:55:03 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: Serverside SNI support in libpq To: pgsql-hackers@lists.postgresql.org From: Cary Huang Cc: Daniel Gustafsson Date: Fri, 24 May 2024 19:54:49 +0000 User-Agent: pgcommitfest X-cfsender: cary In-Reply-To: <1C81CD0D-407E-44F9-833A-DD0331C202E5@yesql.se> References: <1C81CD0D-407E-44F9-833A-DD0331C202E5@yesql.se> <1C81CD0D-407E-44F9-833A-DD0331C202E5@yesql.se> Message-ID: <171658048932.1105.8754500817650927969.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgbm90IHRlc3RlZApJbXBs ZW1lbnRzIGZlYXR1cmU6ICAgICAgIG5vdCB0ZXN0ZWQKU3BlYyBjb21wbGlhbnQ6ICAgICAgICAg ICBub3QgdGVzdGVkCkRvY3VtZW50YXRpb246ICAgICAgICAgICAgbm90IHRlc3RlZAoKVGhpcyBp cyBhbiBpbnRlcmVzdGluZyBmZWF0dXJlIG9uIFBvc3RncmVTUUwgc2VydmVyIHNpZGUgd2hlcmUg aXQgY2FuIHN3YXAgdGhlDQpjZXJ0aWZpY2F0ZSBzZXR0aW5ncyBiYXNlZCBvbiB0aGUgaW5jb21p bmcgaG9zdG5hbWVzIGluIFNOSSBmaWVsZCBpbiBjbGllbnQNCmhlbGxvIG1lc3NhZ2UuDQoNCkkg dGhpbmsgdGhpcyBwYXRjaCByZXNvbmF0ZSB3aXRoIGEgcGF0Y2ggSSBzaGFyZWQgYXdoaWxlIGFn bw0KKCBodHRwczovL2NvbW1pdGZlc3QucG9zdGdyZXNxbC5vcmcvNDgvNDkyNC8gKSB0aGF0IGFk ZHMgbXVsdGlwbGUgY2VydGlmaWNhdGUNCnN1cHBvcnQgb24gdGhlIGxpYnBxIGNsaWVudCBzaWRl IHdoaWxlIHRoaXMgcGF0Y2ggYWRkcyBtdWx0aXBsZSBjZXJ0aWZpY2F0ZQ0Kc3VwcG9ydCBvbiB0 aGUgc2VydmVyIHNpZGUuIE15IHBhdGNoIGFsbG93cyB1c2VyIHRvIHN1cHBseSBtdWx0aXBsZSBj ZXJ0cywga2V5cywNCnNzbHBhc3N3b3JkcyBpbiBjb21tYSBzZXBhcmF0ZWQgZm9ybWF0IGFuZCB0 aGUgbGlicHEgY2xpZW50IHdpbGwgcGljayBvbmUgdGhhdA0KbWF0Y2hlcyB0aGUgQ0EgaXNzdWVy IG5hbWVzIHNlbnQgYnkgdGhlIHNlcnZlci4gSW4gcmVsYXRpb24gd2l0aCB5b3VyIHBhdGNoLA0K dGhpcyBDQSBpc3N1ZXIgbmFtZSB3b3VsZCBtYXRjaCB0aGUgQ0EgY2VydGlmaWNhdGUgY29uZmln dXJlZCBpbiBwZ19ob3N0cy5jZmcuDQoNCkkgaGFkIGEgbG9vayBhdCB0aGUgcGF0Y2ggYW5kIGhl cmUncyBteSBjb21tZW50czoNCg0KKyAgIDxwYXJhPg0KKyAgICA8cHJvZHVjdG5hbWU+UG9zdGdy ZVNRTDwvcHJvZHVjdG5hbWU+IGNhbiBiZSBjb25maWd1cmVkIGZvcg0KKyAgICA8YWNyb255bT5T Tkk8L2Fjcm9ueW0+IHVzaW5nIHRoZSA8ZmlsZW5hbWU+cGdfaG9zdHMuY29uZjwvZmlsZW5hbWU+ DQorICAgIGNvbmZpZ3VyYXRpb24gZmlsZS4gPHByb2R1Y3RuYW1lPlBvc3RncmVTUUw8L3Byb2R1 Y3RuYW1lPiBpbnNwZWN0cyB0aGUgVExTDQorICAgIGhvc3RuYW1lIGV4dGVuc2lvbiBpbiB0aGUg U1NMIGNvbm5lY3Rpb24gaGFuZHNoYWtlLCBhbmQgc2VsZWN0cyB0aGUgcmlnaHQNCisgICAgU1NM IGNlcnRpZmljYXRlLCBrZXkgYW5kIENBIGNlcnRpZmljYXRlIHRvIHVzZSBmb3IgdGhlIGNvbm5l Y3Rpb24uDQorICAgPC9wYXJhPg0KDQpwZ19ob3N0cyBzaG91bGQgYWxzbyBoYXZlIHNzbHBhc3N3 b3JkX2NvbW1hbmQganVzdCBsaWtlIGluIHRoZSBwb3N0Z3Jlc3FsLmNvbmYgaW4NCmNhc2UgdGhl IHNzbGtleSBmb3IgYSBwYXJ0aWN1bGFyIGhvc3QgaXMgZW5jcnlwdGVkIHdpdGggYSBkaWZmZXJl bnQgcGFzc3dvcmQuDQoNCisJLyoNCisJICogSW5zdGFsbCBTTkkgVExTIGV4dGVuc2lvbiBjYWxs YmFjayBpbiBjYXNlIHRoZSBzZXJ2ZXIgaXMgY29uZmlndXJlZCB0bw0KKwkgKiB2YWxpZGF0ZSBo b3N0bmFtZXMuDQorCSAqLw0KKwlpZiAoc3NsX3NuaW1vZGUgIT0gU1NMX1NOSU1PREVfT0ZGKQ0K KwkJU1NMX0NUWF9zZXRfdGxzZXh0X3NlcnZlcm5hbWVfY2FsbGJhY2soY29udGV4dCwgc25pX3Nl cnZlcm5hbWVfY2IpOw0KDQpJZiBsaWJwcSBjbGllbnQgZG9lcyBub3QgcHJvdmlkZSBTTkksIHRo aXMgY2FsbGJhY2sgd2lsbCBub3QgYmUgY2FsbGVkLCBzbyB0aGVyZQ0KaXMgbm90IGEgY2hhbmNl IHRvIGNoZWNrIGZvciBhIGhvc3RuYW1lIG1hdGNoIGZyb20gcGdfaG9zdHMsIHN3YXAgdGhlIFRM UyBDT05URVhULA0Kb3IgcG9zc2libHkgcmVqZWN0IHRoZSBjb25uZWN0aW9uIGV2ZW4gaW4gc3Ry aWN0IG1vZGUuIFRoZSBUTFMgaGFuZHNoYWtlIGluIHN1Y2gNCmNhc2Ugc2hhbGwgcHJvY2VlZCBh bmQgc2VydmVyIHdpbGwgdXNlIHRoZSBjZXJ0aWZpY2F0ZSBzcGVjaWZpZWQgaW4NCnBvc3RncmVz cWwuY29uZiAoaWYgdGhlc2UgYXJlIGxvYWRlZCkgdG8gY29tcGxldGUgdGhlIGhhbmRzaGFrZSB3 aXRoIHRoZSBjbGllbnQuDQpUaGVyZSBpcyBhIGNvbW1lbnQgaW4gdGhlIHBhdGNoIHRoYXQgcmVh ZHM6DQoNCj4gIC0gc3RyaWN0OiBvbmx5IHBnX2hvc3RzLmNvbmYgaXMgbG9hZGVkIGFuZCB0aGUg VExTIGV4dGVuc2lvbiBob3N0bmFtZQ0KPiAgIE1VU1QgYmUgcGFzc2VkIGFuZCBNVVNUIGhhdmUg YSBtYXRjaCBpbiB0aGUgY29uZmlndXJhdGlvbiwgZWxzZSB0aGUNCj4gIGNvbm5lY3Rpb24gaXMg cmVmdXNlZC4NCg0KSSBhbSBub3Qgc3VyZSBpZiBpdCBpbXBsaWVzIHRoYXQgaWYgc3NsX3NuaW1v ZGUgaXMgc3RyaWN0LCB0aGVuIHRoZSBub3JtYWwgc3NsX2NlcnQsDQpzc2xfa2V5IGFuZCBjYV9j ZXJ04oCmZXRjIHNldHRpbmdzIGluIHBvc3RncmVzcWwuY29uZiBhcmUgaWdub3JlZD8NCg0KdGhh bmsgeW91DQoNCkNhcnkgSHVhbmcNCi0tLS0tLS0tLS0tLS0NCkhpZ2hHbyBTb2Z0d2FyZSBJbmMu IChDYW5hZGEpDQpjYXJ5Lmh1YW5nQGhpZ2hnby5jYQ0Kd3d3LmhpZ2hnby5jYQ==