The specified module could not be found. Postgres 15.2 with timescale 2.10.3.

huangapple go评论82阅读模式
英文:

The specified module could not be found. Postgres 15.2 with timescale 2.10.3

问题

I am trying to add timescaledb extension in my postgres 15.2 with timescale 2.10.3.

When I run the command

create extension if not exists timescaledb;

I get below message

> could not load library "C:/Program Files/PostgreSQL/15/lib/timescaledb-2.10.3.dll": The specified module could not be found.

On physically verifying, the file is present there.

Also tried copying files libeay32.dll and ssleay32.dll, still same error.

I have only postgres 15.2 in my system

英文:

I am trying to add timescaledb extension in my postgres 15.2 with timescale 2.10.3.

When I run the command

create extension if not exists timescaledb;

I get below message

> could not load library "C:/Program Files/PostgreSQL/15/lib/timescaledb-2.10.3.dll": The specified module could not be found.

On physically verifying, the file is present there.

Also tried copying files libeay32.dll and ssleay32.dll, still same error.

I have only postgres 15.2 in my system

答案1

得分: 1

这似乎是Windows中已知的问题(https://github.com/timescale/timescaledb/issues/5631)
如果您在本地计算机上运行Postgres,我更喜欢从源代码安装
或者使用如下的TimescaleDB Docker镜像

请按照以下步骤进行源代码安装
https://docs.timescale.com/self-hosted/latest/install/installation-source/

如果您需要安装方面的进一步帮助,请告诉我。

英文:

This seems to be known issue in windows(https://github.com/timescale/timescaledb/issues/5631)
I would prefer installing from source if you are running the postgres in local machine
Or use timescaledb docker image as below

 timescale:
    image: timescale/timescaledb
    container_name: timescale
    environment:
      - POSTGRES_USER=postgres      
      - POSTGRES_PASSWORD=postgres      
    restart: on-failure
    ports:
      - "5432:5432"
    volumes:
      - timescale-data:/home/postgres/pgdata/data/

Please follow the steps below for installing from source
https://docs.timescale.com/self-hosted/latest/install/installation-source/

Let me know if you need any further help with the installation

答案2

得分: 0

你似乎应该在系统中找到两个名为libcrypto-1_1-x64.dlllibssl-1_1-x64.dll的DLL文件,然后将它们都复制到Postgres的bin文件夹中。
我在我的系统中通过在C:\Windows\System32文件夹中按名称搜索的方式找到了这些DLL文件,它们位于这里(在您的系统中路径可能不同):C:\Windows\System32\DriverStore\FileRepository\iclsclient.inf_amd64_76523213b78d9046\lib
然后,我将它们复制并粘贴到bin文件夹中,重新启动了Postgres的Windows服务,一切都开始正常工作了。
感谢Dependencies x64,我在那里打开了"C:/Program Files/PostgreSQL/15/lib/timescaledb-2.10.3.dll"并发现了缺失的DLL文件。

英文:

It seems you should find in your system two dlls libcrypto-1_1-x64.dll and libssl-1_1-x64.dll and copy both of them to Postgres bin folder.
I somehow found these dlls in my system just searching by name in C:\Windows\System32 folder and they were found here (in your system the path can be different) C:\Windows\System32\DriverStore\FileRepository\iclsclient.inf_amd64_76523213b78d9046\lib.
Then I copied and pasted them to bin folder and restarted Postgres windows service and everything started working well.
Thanks for the Dependencies x64 I opened "C:/Program Files/PostgreSQL/15/lib/timescaledb-2.10.3.dll" there and saw missing dlls.

huangapple
  • 本文由 发表于 2023年5月11日 15:28:46
  • 转载请务必保留本文链接:https://go.coder-hub.com/76225090.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定