ODBC SSL connection issue on Solaris with PostgreSQL 18 (OpenSSL 1.0.2) - Mailing list pgsql-general

Hi Team,

I am trying to configure PostgreSQL ODBC connectivity from an Oracle Solaris server.

Since Solaris does not provide prebuilt PostgreSQL ODBC packages like RHEL-based systems, the official PostgreSQL ODBC source code was downloaded from the PostgreSQL repository and compile on the server.

Environment:

- OS: Solaris

- GCP CloudSQL PostgreSQL Server: Version 18

- ODBC Driver: psqlODBC 16

- PostgreSQL Client (libpq): 18

- OpenSSL: 1.0.2zj

Issue:

Connection fails with error:

"pg_hba.conf rejects connection ... no encryption"

Observation:

- PostgreSQL server enforces SSL (TLS 1.2+)

- Client build does not support SSL due to OpenSSL version

- PostgreSQL configure fails when enabling SSL:

  "OpenSSL version >= 1.1.1 is required"

Question:

Is there any supported way to enable SSL connectivity on Solaris with OpenSSL 1.0.2, or is upgrading OpenSSL the only option?

Thanks,

Arun