You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.04.14 16:35:29