model-writtenrun 2284 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- George MacKerron opened the thread with a Windows-tested patch making sslrootcert=system load the Windows certificate store on OpenSSL 3.2 or later, motivated by its failure to work with the EDB Windows installation #1.
- Jacob Champion and Daniel Gustafsson objected that replacing OpenSSL defaults would break existing certificate configurations and environment overrides, so George revised the patch to retain the defaults when either certificate environment variable is set #2 #3 #4.
- George acknowledged that compiled-in OPENSSLDIR configurations still needed protection, and Jacob argued that the existing meaning of system should remain stable; Daniel supplied a separate documentation clarification and proposed a richer certificate-store interface for future work #5 #6 #7.
- George endorsed the documentation correction but requested a broadly usable Windows solution, suggesting sslrootcert=os; Daniel rejected rushing new security behavior into the approaching feature freeze or a minor release and emphasized retaining access to both OpenSSL defaults and alternative stores #9 #12.
- Daniel committed the documentation patch from #7 as dda1b06035, changing only line wrapping and backpatching through v16, then announced the landing in #13.
- After a nearly three-week gap, George proposed new openssl and os values plus a larger redesign making sslmode=secure the default; Christoph Berg supported improving security but warned that installations without properly configured certificates would face widespread breakage and needed better client controls #14 #15.
- George revived the Windows implementation with an additional compatibility safeguard: use winstore only when neither certificate environment override is set and neither OpenSSL's default certificate file nor directory exists #16.
- The broader discussion explored explicit psql SSL switches, localhost certificate complications, and a separate postgress:// scheme with stronger defaults and authority semantics, without producing another attached implementation #17 #18 #19.
- Jacob argued against adding more reserved sslrootcert values or silently falling back between trust stores, favoring an explicit interface; Jelte Fennema-Nio instead proposed a compile-time store choice to preserve one portable connection string, and George accepted the concern about new reserved values while continuing to advocate his fallback or the compile-time alternative #20 #21 #23 #24 #25.
- Jelte challenged the already-landed documentation change as legitimizing undesirable behavior, while George distinguished accurate documentation from the behavior he wanted changed; no revert followed in the supplied thread #26 #27.
- Responding to Daniel's request for concrete configuration details, George demonstrated that EDB's Windows installation had a valid OPENSSLDIR but no certificates, and that installing a CA bundle there made sslrootcert=system work; Daniel acknowledged the findings #28 #30 #31.
- The thread ended with only the documentation clarification landed: Windows-store support and stronger connection defaults remained unresolved, while Daniel opposed TLS-prefixed option aliases and Jacob emphasized secure URL authority handling and suggested global client configuration to ease future default changes #29 #32 #33.