[MacPorts] #72080: postgresql16, postgresql17: sslrootcert=system fails

[MacPorts]

#72080: postgresql16, postgresql17: sslrootcert=system fails
-----------------------------------------+----------------------
  Reporter:  jawj                        |      Owner:  dgilman
      Type:  defect                      |     Status:  assigned
  Priority:  Normal                      |  Milestone:
 Component:  ports                       |    Version:  2.10.5
Resolution:                              |   Keywords:
      Port:  postgresql16, postgresql17  |
-----------------------------------------+----------------------

Comment (by dgilman):

 Apologies for the delay, had put this off. I was not familiar with this
 feature at all. Looking at the PostgreSQL source, it looks like it just
 calls the OpenSSL function `SSL_CTX_set_default_verify_paths` for this.
 OpenSSL docs make it sound like that is supposed to be an all-inclusive
 function that takes care of all the configuration details for you. So I
 don't think there's anything for PostgreSQL to do here, it's doing what it
 needs to do with OpenSSL, but the MacPorts OpenSSL's
 `SSL_CTX_set_default_verify_paths` is not configuring itself correctly.

 I can confirm that libpq is linking against openssl3. I would reassign
 this ticket to the openssl3 maintainer to see if they have any input?

-- 
Ticket URL: <https://trac.macports.org/ticket/72080#comment:3>
MacPorts <https://www.macports.org/>
Ports system for macOS