英文:
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.dll
和libssl-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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论