PG 15 < 15.6 incompatible with OpenSSL 3.2+

Summary

As seen in !2099 (closed)'s findings, PG 15.1 needs either patched, or updated to account for an incompatibility with OpenSSL 3.2.x+

In particular, PG 15 < 15.6

Details

Further reading, start at this conversation related to identification.

I see there is a Homebrew patch to fix libpq support with OpenSSL 3.2: https://github.com/Homebrew/homebrew-core/pull/155699. PostgreSQL shipped this version in a recent version: https://github.com/postgres/postgres/commit/c82207a548db47623a2bfa2447babdaa630302b9

This change was included into 15.6 (https://github.com/postgres/postgres/commit/5dd30bb54bfec14e5677aff3e306edec79c204ef) and is present in all future releases.

Actionable

• Choose
  • Update earlier stables to 15.6+
  • Add patch to 15.x for earlier stables
  • Backport 16.x+ to earlier stables
• Implement these changes through appropriate versions.