Edward Breen <ebreen@wexusapp.com> writes:
> It appears the issue isn't fully resolved. I still see the expired root
> certificate DST Root CA X3 with openssl:
> % openssl s_client -connect www.postgresql.org:443 -servername
> www.postgresql.org
This did before, and still does, indicate either an obsolete system trust
store or an obsolete OpenSSL version on your end. You need to make sure
the "ISRG Root X1" cert is trusted by your machine, and you need to make
sure you're running moderately recent OpenSSL (preferably > 1.0.2).
If the latter is impractical, there are workarounds here:
https://www.openssl.org/blog/blog/2021/09/13/LetsEncryptRootCertExpire/
regards, tom lane