psycopg2安装问题

Question

当我启动Django服务器时，会得到以下错误：

Failed to get real commands on module "mysite": python process died with code 1: Traceback (most recent call last):
  File "C:\Users\Jack\Anaconda3\envs\mysite\lib\site-packages\django\db\backends\postgresql\base.py", line 25, in <module>
    import psycopg2 as Database
  File "C:\Users\Jack\Anaconda3\envs\mysite\lib\site-packages\psycopg2\__init__.py", line 50, in <module>
    from psycopg2._psycopg import (                     # noqa
ImportError: DLL load failed while importing _psycopg: The specified module could not be found.



During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files\JetBrains\PyCharm 2019.3.1\plugins\python\helpers\pycharm\_jb_manage_tasks_provider.py", line 25, in <module>
    django.setup()
  File "C:\Users\Jack\Anaconda3\envs\mysite\lib\site-packages\django\__init__.py", line 24, in setup

安装库后，当我检查psycopg2目录时，__init__.py包含from psycopg2._psycopg import ...。但是，在_psycopg.dll目录中没有psycopg2文件。可能是窃听器？

我的settings.py的一部分：

DATABASES = {
    "default": {
        "ENGINE": "django.db.backends.postgresql",
        "NAME": "database1",
        "USER": "postgres",
        "PASSWORD": "123456",
        "HOST": "127.0.0.1",
        "PORT": "5432"
    }
}

使用：

Windows 10

PyCharm

蟒蛇

Python 3.8.3

psycopg2 2.8.4

Django 3.0.3

PostgreSQL

Answer 1

有同样的问题，我添加了路径到bin文件夹的postgres到PATH。这很有帮助。