Flask+SQLAlchemy连接PostgreSQL时_psycopg导入DLL加载失败的解决求助
Flask+SQLAlchemy连接PostgreSQL时_psycopg导入DLL加载失败的解决求助
我最近在开发一个基于Flask、SQLAlchemy和PostgreSQL的项目,结果启动Flask应用的时候直接报错卡壳了,实在找不到解决办法,来求助大家!
启动时的完整错误信息如下:
Error: While importing 'app', an ImportError was raised: Traceback (most recent call last): File "path\to\project\app.py", line 8, in db = SQLAlchemy(app) File "path\to\virtualenv\Lib\site-packages\flask_sqlalchemy\extension.py", line 278, in __init__ self.init_app(app) File "path\to\virtualenv\Lib\site-packages\flask_sqlalchemy\extension.py", line 374, in init_app engines[key] = self._make_engine(key, options, app) File "path\to\virtualenv\Lib\site-packages\flask_sqlalchemy\extension.py", line 665, in _make_engine return sa.engine_from_config(options, prefix="") File "path\to\virtualenv\Lib\site-packages\sqlalchemy\engine\create.py", line 820, in engine_from_config return create_engine(url, **options) File "path\to\virtualenv\Lib\site-packages\sqlalchemy\engine\create.py", line 599, in create_engine dbapi = dbapi_meth(**dbapi_args) File "path\to\virtualenv\Lib\site-packages\sqlalchemy\dialects\postgresql\psycopg2.py", line 690, in import_dbapi import psycopg2 File "path\to\virtualenv\Lib\site-packages\psycopg2\__init__.py", line 51, in from psycopg2._psycopg import ( # noqa ... ImportError: DLL load failed while importing _psycopg: The specified module could not be found.
我的环境信息:
- Python版本:3.13.0
- Flask版本:3.1.0
- SQLAlchemy版本:2.0.36
- psycopg2相关:先后试过安装psycopg2原版和psycopg2-binary 2.9.10,均无效
- PostgreSQL版本:17.2
- 操作系统:Windows 10 22H2
我已经尝试过的解决步骤:
- 交替安装psycopg2和psycopg2-binary两个版本,问题未解决
- 重新安装了最新版的Visual C++ Redistributable
- 将PostgreSQL的bin目录添加到了系统环境变量Path中
有没有朋友遇到过类似的问题?或者能给我一些新的排查方向吗?万分感谢!
备注:内容来源于stack exchange,提问作者Shalva Mosiashvili
相关产品推荐
相关产品推荐

