sslinfo extension - add notbefore and notafter timestamps

Cary Huang <cary.huang@highgo.ca>

From: Cary Huang <cary.huang@highgo.ca>

To: "Pgsql Hackers" <pgsql-hackers@postgresql.org>

Date: 2022-08-19T23:00:41Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add notBefore and notAfter to SSL cert info display
- 6acb0a628ecc 17.0 landed
- 75ec5e7bec70 17.0 landed
Set fixed dates for test certificates validity
- 40fad96530ca 17.0 landed

Attachments

v1-0001-sslinfo-add-notbefore-and-notafter-timestamps.patch (application/octet-stream) patch v1-0001

Hello



I noticed that sslinfo extension does not have functions to return current client certificate's notbefore and notafter timestamps which are also quite important attributes in a X509 certificate. The attached patch adds 2 functions to get notbefore and notafter timestamps from the currently connected client certificate.



thank you!







Cary Huang

-------------

HighGo Software Inc. (Canada)

mailto:cary.huang@highgo.ca

http://www.highgo.ca