[MacPorts] #68777: postgresql16 @16.1: cannot connect to servers that require SSL since last update

[MacPorts]

#68777: postgresql16 @16.1: cannot connect to servers that require SSL since last
update
----------------------------------------+----------------------
  Reporter:  davidnich                  |      Owner:  dgilman
      Type:  defect                     |     Status:  assigned
  Priority:  Normal                     |  Milestone:
 Component:  ports                      |    Version:  2.8.1
Resolution:                             |   Keywords:
      Port:  postgresql15 postgresql16  |
----------------------------------------+----------------------

Comment (by neverpanic):

 I cannot reproduce that:

 {{{
 $ sudo port install postgresql16-server
 $ sudo port select postgresql postgresql16
 $ sudo mkdir -p /opt/local/var/db/postgresql16/defaultdb
 $ sudo chown postgres:postgres /opt/local/var/db/postgresql16/defaultdb
 $ sudo -u postgres /bin/sh -c 'cd /opt/local/var/db/postgresql16 &&
 /opt/local/lib/postgresql16/bin/initdb -D
 /opt/local/var/db/postgresql16/defaultdb'
 $ sudo -u postgres openssl req -new -x509 -days 365 -nodes -out
 /opt/local/var/db/postgresql16/server.crt -keyout
 /opt/local/var/db/postgresql16/server.key -subj "/CN=localhost"
 $ sudo -u postgres /bin/sh -c '(echo "ssl =  on"; echo "ssl_cert_file =
 \'server.crt\'"; echo "ssl_key_file = \'server.key\'")
 >/opt/local/var/db/postgresql16/postgresql.conf'
 $ sudo port load postgresql16-server
 $ psql "sslmode=require host=localhost user=postgres dbname=postgres"
 psql (16.1)
 SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384,
 compression: off)
 Type "help" for help.

 postgres=#
 \q
 }}}

 I did install PostgreSQL (both the server and client) from the precompiled
 binary, which was built before the OpenSSL 3.2.0 update, so that should
 have been built against OpenSSL 3.1.4.

 I'm on 13.6.2, also on arm64.

 Do you have any further details of the server setup?

 There is also a similar report at https://lists.macports.org/pipermail
 /macports-users/2023-November/052378.html, so I am sure there is some
 issue, but it would help if I could reproduce it.

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