[Bug]: error: PostgreSQL/15/lib/timescaledb-2.10.2.dll Unable to load library The specified module could not be found

[lyriumbytes]

What type of bug is this?

Configuration

What subsystems and features are affected?

Configuration

What happened?

Seems to be that the dependencies libssl-1_1-x64.dll and libcrypto-1_1-x64.dll are missing after installation. We were able to fix it by adding C:\Program Files\Git\mingw64\bin as system variable. Dlls are not present in the lib Folder of the Postgresql installation, only similarly named ones i.e. libssl-3-x64.dll were present.

TimescaleDB version affected

2.10.2

PostgreSQL version used

15.2

What operating system did you use?

Windows 10

What installation method did you use?

Other

What platform did you run on?

On prem/Self-hosted

Relevant log output and stack trace

No response

How can we reproduce the bug?

Clean Windows machine without anything else apart from an installation of PostgreSQL.

[lyriumbytes]

did you find a solution for this problem ? i have the same issue, i'm not able to start my pg server

Installed git, those files are present in mingw64/bin. Either move them to the Postgres lib folder or add the path to env variables.

[Vildsvinet]

" adding C:\Program Files\Git\mingw64\bin as system variable. "
this worked for me too. crazy. original error message wasn't very helpful, was it. but thanks! :)

[mahipv]

Hi @lyriumbytes,

Thank you for raising the issue. Currently there is a requirement of having OpenSSL 1.1.1 to install TimescaleDB with PostgreSQL 15.0.1 and later on Windows.

It has been documented
https://docs.timescale.com/self-hosted/latest/install/installation-windows/#prerequisites

[jvanlangen]

This is still a problem today..

[jnidzwetzki]

Hi @jvanlangen,

Thanks for bringing this up. Could you elaborate on which kind of problem you face? Did the installation of OpenSSL not help to load the extension?

[amiller8605]

I also had this issue with 2.14.2.

According to the Prerequisites:
_To install TimescaleDB 2.11.2 or later, make sure you have installed OpenSSL 3.x.
For older versions of TimescaleDB, OpenSSL 1.1.1 is required.

So, I tried with OpenSSL-3 installed but still got the error message:
_ERROR: could not load library "...timescaledb-2.14.2.dll": The specified module could not be found.

Troubleshooting with Dependency Walker revealed that the library needed OpenSSL-1 dll files, not OpenSSL-3. After I got that in place, it worked.

[basicbasic]

Temporary workaround based on Sanprof's comment here: https://stackoverflow.com/questions/76225090/the-specified-module-could-not-be-found-postgres-15-2-with-timescale-2-10-3

For Windows you can download the dlls you need here: https://wiki.overbyte.eu/wiki/index.php/ICS_Download
At this link: https://wiki.overbyte.eu/arch/openssl-1.1.1w-win64.zip
Needless to say that an unsupported version of SSL will likely be removed sooner rather then later.

Unzip this and you'll find libcrypto-1_1-x64.dll and lbssl-1_1-x64.dll without having to install anything. Copy them to the your postgres versions lib directory (e.g. C:\Program Files\PostgreSQL\16\lib) and the extension can be created.

V16 of Postgres, V2.14.2 of timescaledb and Windows 11.

[mosesarigbedered]

Temporary workaround based on Sanprof's comment here: https://stackoverflow.com/questions/76225090/the-specified-module-could-not-be-found-postgres-15-2-with-timescale-2-10-3

For Windows you can download the dlls you need here: https://wiki.overbyte.eu/wiki/index.php/ICS_Download At this link: https://wiki.overbyte.eu/arch/openssl-1.1.1w-win64.zip Needless to say that an unsupported version of SSL will likely be removed sooner rather then later.

Unzip this and you'll find libcrypto-1_1-x64.dll and lbssl-1_1-x64.dll without having to install anything. Copy them to the your postgres versions lib directory (e.g. C:\Program Files\PostgreSQL\16\lib) and the extension can be created.

V16 of Postgres, V2.14.2 of timescaledb and Windows 11.

This worked. Use the bin folder instead though.