add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl

Edit
ID 4390
Title add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl
CI (CFBot) Needs rebase! Needs rebase since 3 weeks. Failing since 3 weeks.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Tags Security
Created 2023-06-23 21:26:18
Last modified 2026-04-02 20:40:54 (22 hours ago)
Latest email 2025-06-05 22:31:44 (9 months ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
2024-03 (2024-03-01 – 2024-04-08): Moved to different CF
2024-01 (2024-01-01 – 2024-01-31): Moved to different CF
2023-11 (2023-11-01 – 2023-12-04): Moved to different CF
2023-09 (2023-09-01 – 2023-09-30): Moved to different CF
2023-07 (2023-07-01 – 2023-07-31): Moved to different CF
Target version
Authors Cary Huang (cary)
Reviewers Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion)Become reviewer
Committer
Links
Emails
sslinfo extension - add notbefore and notafter timestamps
First at 2022-08-19 23:00:41 by Cary Huang <cary.huang at highgo.ca>
Latest at 2025-06-05 22:31:44 by Cary Huang <cary.huang at highgo.ca>
Latest attachment (v15-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-disp.patch) at 2025-06-05 22:31:44 from Cary Huang <cary.huang at highgo.ca>
    Attachment (v15-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-disp.patch) at 2025-06-05 22:31:44 from Cary Huang <cary.huang at highgo.ca> (Patch: Yes)
    Attachment (v14-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-disp.patch) at 2025-03-10 19:29:28 from Cary Huang <cary.huang at highgo.ca> (Patch: Yes)
    Attachment (v13-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-disp.patch) at 2024-10-28 08:59:35 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v12-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-disp.patch) at 2024-03-22 13:14:57 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v11-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-disp.patch) at 2024-03-20 14:03:45 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v10-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-displ.patch) at 2024-03-18 20:48:54 from Cary Huang <cary.huang at highgo.ca> (Patch: Yes)
    Attachment (v9-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-displ.patch) at 2024-03-09 00:16:35 from Cary Huang <cary.huang at highgo.ca> (Patch: Yes)
    Attachment (timestamptz.diff.txt) at 2024-03-05 21:54:09 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v8-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-displ.patch) at 2023-09-15 13:34:35 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v7-0001-Add-notBefore-and-notAfter-to-SSL-cert-info-displ.patch) at 2023-07-25 14:21:42 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v6-0001-Set-fixed-dates-for-test-certificates-validity.patch) at 2023-07-17 18:26:40 from Cary Huang <cary.huang at highgo.ca> (Patch: Yes)
    Attachment (v5-0001-Set-fixed-dates-for-test-certificates-validity.patch) at 2023-07-13 16:03:21 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (v4-0001-sslinfo-add-notbefore-and-notafter-timestamps.patch) at 2023-07-10 23:09:51 from Cary Huang <cary.huang at highgo.ca> (Patch: Yes)
    Attachment (v3-0001-sslinfo-add-notbefore-and-notafter-timestamps.patch) at 2023-06-30 18:12:03 from Cary Huang <cary.huang at highgo.ca> (Patch: Yes)
    Attachment (v2-0001-sslinfo-add-notbefore-and-notafter-timestamps.patch) at 2023-06-23 20:10:22 from Cary Huang <cary.huang at highgo.ca> (Patch: Yes)
    Attachment (v1-0001-sslinfo-add-notbefore-and-notafter-timestamps.patch) at 2022-08-19 23:00:41 from Cary Huang <cary.huang at highgo.ca> (Patch: Yes)
History
When Who What
2026-04-02 20:40:54 Daniel Gustafsson (d_gustafsson) Moved from CF PG19-Final to CF PG20-1
2026-03-08 11:43:24 CFbot Patch needs rebase
2026-02-28 18:02:37 Daniel Gustafsson (d_gustafsson) Moved from CF PG19-1 to CF PG19-Final
2025-06-05 23:14:38 CFbot Patch does not need rebase anymore
2025-05-30 18:41:33 CFbot Patch needs rebase
2025-03-10 21:53:31 Cary Huang (cary) New status: Needs review
2025-03-10 21:52:33 Cary Huang (cary) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-10 06:30:45 Michael Paquier (michael-kun) Closed in commitfest 2024-11 with status: Moved to next CF
2024-12-10 06:29:40 Michael Paquier (michael-kun) New status: Waiting on Author
2024-10-07 07:06:55 Michael Paquier (michael-kun) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 01:53:56 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-04-09 06:18:44 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-09 06:18:41 Andrey Borodin (x4m) Changed targetversion to None
2024-03-20 14:04:39 Daniel Gustafsson (d_gustafsson) New status: Ready for Committer
2024-02-01 18:01:31 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 10:02:15 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 11:07:53 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-09-12 19:41:05 Jacob Champion (jchampion) Added jchampion as reviewer
2023-08-02 07:50:54 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-08-02 07:50:49 Daniel Gustafsson (d_gustafsson) Changed targetversion to 17
2023-07-11 17:09:32 Cary Huang (cary) New status: Needs review
2023-07-03 09:57:39 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2023-06-30 20:56:52 Cary Huang (cary) New status: Needs review
2023-06-28 06:27:01 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2023-06-28 06:14:35 Daniel Gustafsson (d_gustafsson) Changed reviewers to Daniel Gustafsson (d_gustafsson)
2023-06-23 21:28:33 Cary Huang (cary) Changed reviewers to Daniel Gustafsson (dege)
2023-06-23 21:28:33 Cary Huang (cary) Changed authors to Cary Huang (cary)
2023-06-23 21:28:33 Cary Huang (cary) Changed targetversion to 16
2023-06-23 21:26:18 Cary Huang (cary) Attached mail thread 182b8565486.10af1a86f158715.2387262617218380588@highgo.ca
2023-06-23 21:26:18 Cary Huang (cary) Created patch record
Edit