windows安装psycopg2问题解决方案

最新推荐文章于 2024-11-11 14:38:59 发布

转载最新推荐文章于 2024-11-11 14:38:59 发布 · 202 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Jerryshome/archive/2011/06/28/2092410.html

文章标签：

#python

本文介绍了在Windows环境下使用easy_install安装psycopg2后，在Python中导入时出现DLL加载失败的问题，并提供了解决方案，即通过查找并正确配置libpq.dll来解决此问题。

在windows下使用

easy_installpsycopg2安装psycopg2时安装成功，但在python中import psycopg2时却提示如下错误：

from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: DLL load failed: 找不到指定的模块。

为何？？

 ImportError: DLL load failed: The specified module could not be found.

the file _psycopg.pyd is a dll. For its relatively small size it is
probably dynamically linked to the libpq.dll. I think the system
either fails to find libpq.dll or some of the other dependencies (they
are listed in the setup.py).

I suggest you to use a tool to check its dll dependencies (maybe
http://www.dependencywalker.com/ could be ok) and see if there is
anything missing. If libpq.dll is the missing one, try putting it in a
PATH directory or in the psycopg2 package directory.

具体解决方案如下：
查找libpq.dll，将其copy到psycopg2的包中，或者放置在系统PATH下即可

转载于:https://www.cnblogs.com/Jerryshome/archive/2011/06/28/2092410.html