django项目使用postgis遇到问题django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 module

我的django项目使用了postgis，运行时报错

在我pip install对应的包后会显示不是有效的win32应用程序

完整报错

"D:\DEEP\DEEP LEARNING\python.exe" "D:\djangoProject\test code\manage.py" runserver 8000 
Watching for file changes with StatReloader
Exception in thread django-main-thread:
Traceback (most recent call last):
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\backends\postgresql\base.py", line 25, in <module>
    import psycopg as Database
ModuleNotFoundError: No module named 'psycopg'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\backends\postgresql\base.py", line 27, in <module>
    import psycopg2 as Database
ModuleNotFoundError: No module named 'psycopg2'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "D:\DEEP\DEEP LEARNING\lib\threading.py", line 1016, in _bootstrap_inner
    self.run()
  File "D:\DEEP\DEEP LEARNING\lib\threading.py", line 953, in run
    self._target(*self._args, **self._kwargs)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\utils\autoreload.py", line 64, in wrapper
    fn(*args, **kwargs)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\core\management\commands\runserver.py", line 125, in inner_run
    autoreload.raise_last_exception()
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\utils\autoreload.py", line 87, in raise_last_exception
    raise _exception[1]
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\core\management\__init__.py", line 394, in execute
    autoreload.check_errors(django.setup)()
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\utils\autoreload.py", line 64, in wrapper
    fn(*args, **kwargs)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\__init__.py", line 24, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\apps\registry.py", line 116, in populate
    app_config.import_models()
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\apps\config.py", line 269, in import_models
    self.models_module = import_module(models_module_name)
  File "D:\DEEP\DEEP LEARNING\lib\importlib\__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 883, in exec_module
  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\contrib\auth\models.py", line 3, in <module>
    from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\contrib\auth\base_user.py", line 57, in <module>
    class AbstractBaseUser(models.Model):
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\models\base.py", line 143, in __new__
    new_class.add_to_class("_meta", Options(meta, app_label))
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\models\base.py", line 371, in add_to_class
    value.contribute_to_class(cls, name)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\models\options.py", line 243, in contribute_to_class
    self.db_table, connection.ops.max_name_length()
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\utils\connection.py", line 15, in __getattr__
    return getattr(self._connections[self._alias], item)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\utils\connection.py", line 62, in __getitem__
    conn = self.create_connection(alias)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\utils.py", line 193, in create_connection
    backend = load_backend(db["ENGINE"])
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\utils.py", line 113, in load_backend
    return import_module("%s.base" % backend_name)
  File "D:\DEEP\DEEP LEARNING\lib\importlib\__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\contrib\gis\db\backends\postgis\base.py", line 4, in <module>
    from django.db.backends.postgresql.base import DatabaseWrapper as PsycopgDatabaseWrapper
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\backends\postgresql\base.py", line 29, in <module>
    raise ImproperlyConfigured("Error loading psycopg2 or psycopg module")
django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 or psycopg module
D:\djangoProject\test code\djangoProject1\settings.py changed, reloading.
Watching for file changes with StatReloader
Exception in thread django-main-thread:
Traceback (most recent call last):
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\backends\postgresql\base.py", line 25, in <module>
    import psycopg as Database
ModuleNotFoundError: No module named 'psycopg'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\backends\postgresql\base.py", line 27, in <module>
    import psycopg2 as Database
ModuleNotFoundError: No module named 'psycopg2'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "D:\DEEP\DEEP LEARNING\lib\threading.py", line 1016, in _bootstrap_inner
    self.run()
  File "D:\DEEP\DEEP LEARNING\lib\threading.py", line 953, in run
    self._target(*self._args, **self._kwargs)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\utils\autoreload.py", line 64, in wrapper
    fn(*args, **kwargs)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\core\management\commands\runserver.py", line 125, in inner_run
    autoreload.raise_last_exception()
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\utils\autoreload.py", line 87, in raise_last_exception
    raise _exception[1]
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\core\management\__init__.py", line 394, in execute
    autoreload.check_errors(django.setup)()
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\utils\autoreload.py", line 64, in wrapper
    fn(*args, **kwargs)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\__init__.py", line 24, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\apps\registry.py", line 116, in populate
    app_config.import_models()
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\apps\config.py", line 269, in import_models
    self.models_module = import_module(models_module_name)
  File "D:\DEEP\DEEP LEARNING\lib\importlib\__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
  File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
  File "<frozen importlib._bootstrap_external>", line 883, in exec_module
  File "<frozen importlib._bootstrap>", line 241, in _call_with_frames_removed
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\contrib\auth\models.py", line 3, in <module>
    from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\contrib\auth\base_user.py", line 57, in <module>
    class AbstractBaseUser(models.Model):
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\models\base.py", line 143, in __new__
    new_class.add_to_class("_meta", Options(meta, app_label))
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\models\base.py", line 371, in add_to_class
    value.contribute_to_class(cls, name)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\models\options.py", line 243, in contribute_to_class
    self.db_table, connection.ops.max_name_length()
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\utils\connection.py", line 15, in __getattr__
    return getattr(self._connections[self._alias], item)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\utils\connection.py", line 62, in __getitem__
    conn = self.create_connection(alias)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\utils.py", line 193, in create_connection
    backend = load_backend(db["ENGINE"])
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\utils.py", line 113, in load_backend
    return import_module("%s.base" % backend_name)
  File "D:\DEEP\DEEP LEARNING\lib\importlib\__init__.py", line 126, in import_module
    return _bootstrap._gcd_import(name[level:], package, level)
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\contrib\gis\db\backends\postgis\base.py", line 4, in <module>
    from django.db.backends.postgresql.base import DatabaseWrapper as PsycopgDatabaseWrapper
  File "D:\DEEP\DEEP LEARNING\lib\site-packages\django\db\backends\postgresql\base.py", line 29, in <module>
    raise ImproperlyConfigured("Error loading psycopg2 or psycopg module")
django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 or psycopg module

【相关推荐】

• 这篇博客: pip install psycopg2==2.8 错误异常中的 Error: b’You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.\n’ 部分也许能够解决你的问题, 你可以仔细阅读以下内容或跳转源博客中阅读:
  

  pip install  psycopg2==2.8 -i https://pypi.tuna.tsinghua.edu.cn/simple/
  

  报错：

  Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple/
  Collecting psycopg2==2.8
    Using cached https://pypi.tuna.tsinghua.edu.cn/packages/c7/ca/75236b17f1b951950ffc55d657c5aa408d3d0327a1b6c4c0f7cb16ef7e7b/psycopg2-2.8.tar.gz (367 kB)
      ERROR: Command errored out with exit status 1:
       command: /home/python/.virtualenvs/py3_sf/bin/python3.6 -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-pvc0mswm/psycopg2/setup.py'"'"'; __file__='"'"'/tmp/pip-install-pvc0mswm/psycopg2/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' egg_info --egg-base /tmp/pip-install-pvc0mswm/psycopg2/pip-egg-info
           cwd: /tmp/pip-install-pvc0mswm/psycopg2/
      Complete output (7 lines):
      running egg_info
      creating /tmp/pip-install-pvc0mswm/psycopg2/pip-egg-info/psycopg2.egg-info
      writing /tmp/pip-install-pvc0mswm/psycopg2/pip-egg-info/psycopg2.egg-info/PKG-INFO
      writing dependency_links to /tmp/pip-install-pvc0mswm/psycopg2/pip-egg-info/psycopg2.egg-info/dependency_links.txt
      writing top-level names to /tmp/pip-install-pvc0mswm/psycopg2/pip-egg-info/psycopg2.egg-info/top_level.txt
      writing manifest file '/tmp/pip-install-pvc0mswm/psycopg2/pip-egg-info/psycopg2.egg-info/SOURCES.txt'
      Error: b'You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.\n'
      ----------------------------------------
  ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command output.
  
  

  关键错误看下图标注：
  

  解决：

  sudo apt-get install libpq-dev
  

  安装成功后，再次以下安装命令

  pip install  psycopg2==2.8 -i https://pypi.tuna.tsinghua.edu.cn/simple/
  
  

  成功安装！！！
  

如果你已经解决了该问题, 非常希望你能够分享一下解决方案, 写成博客, 将相关链接放在评论区, 以帮助更多的人 ^-^