ModuleNotFoundError: No module named ‘psycopg2‘问题及解决

报错如下

(venv) D:\geodj\geodjango>python manage.py makemigrations
Traceback (most recent call last):
  File "D:\geodj\venv\lib\site-packages\django\db\backends\postgresql\base.py", line 25, 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 "manage.py", line 21, in <module>
    main()
  File "manage.py", line 17, in main
    execute_from_command_line(sys.argv)
	···
    from django.db.backends.postgresql.base import (
  File "D:\geodj\venv\lib\site-packages\django\db\backends\postgresql\base.py", line 29, in <module>
    raise ImproperlyConfigured("Error loading psycopg2 module: %s" % e)
django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 module: No module named 'psycopg2'

解决方法

(venv) D:\geodj\geodjango>pip install psycopg2
Collecting psycopg2
  Using cached psycopg2-2.8.5-cp37-cp37m-win_amd64.whl (1.1 MB)
Installing collected packages: psycopg2
Successfully installed psycopg2-2.8.5