search

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
17.33k stars 869 forks source link

libssl.so.1.1: cannot open shared object file: No such file or directory #732

Closed alanhamlett closed 5 years ago

alanhamlett commented 5 years ago

After installing timescale when I try to enable the extension I get this error:

# CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;
ERROR:  could not load library "/usr/lib/postgresql/10/lib/timescaledb-1.0.0-rc1.so": libssl.so.1.1: cannot open shared object file: No such file or directory

I've installed openssl v1.1.1 from source, maybe it's related?

alanhamlett commented 5 years ago

I had installed postgres, then openssl, then timescaledb... installing openssl first before installing postgres fixed it.

FlorianWendelborn commented 1 month ago

I had a similar issue and in my case it was due to mounting a database generated by a different machine into the container. It worked fine with a clean database. Just in case anyone else runs into something similar:

ERROR: could not load library "/usr/local/lib/postgresql/timescaledb-2.8.1.so": Error loading shared library libssl.so.1.1: No such file or directory (needed by /usr/local/lib/postgresql/timescaledb-2.8.1.so)

Since this happened on a dev setup making a new DB was sufficient for me. Good luck if you landed here through a search engine