ODBC SSL connection issue on Solaris with PostgreSQL 18 (OpenSSL 1.0.2)
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
On 4 May 2026, at 15:46, arun nair <arun18.nair@gmail.com> wrote:
Is there any supported way to enable SSL connectivity on Solaris with OpenSSL 1.0.2, or is upgrading OpenSSL the only option?
PostgreSQL 18 requires OpenSSL 1.1.1, there is no possibility to use 1.0.2.
--
Daniel Gustafsson
On Mon, May 04, 2026 at 07:16:28PM +0530, arun nair wrote:
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.
...
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
Hi Arun,
Could you use a statically linked program like stunnel to provide the
higher SSL version support. You would connect to it locally.
Regards,
Ken
