No module named 'psycopg2'

Question

I Installed psycopg2 using pip

Click to copy

C:\Users\username>python -m pip install psycopg2

Adjusted my settings to:

Click to copy

DATABASES = {
  'default': {
    'ENGINE': 'django.db.backends.postgresql_psycopg2', # also tried: django.db.backends.postgresql
    'NAME': 'name',
    'USER': 'user',
    'PASSWORD': 'my_password',
    'HOST': 'localhost',
    'PORT': '5432',
   }
}

When I attempt to run the server:

import psycopg2 as Database ImportError:

No module named 'psycopg2'

So I ran this again and got:

python -m pip install psycopg2 Requirement already satisfied (use --upgrade to upgrade): psycopg2 in ...

So what have I done wrong? I am new to Django

Answer 1

There is a possibility that you have two versions of python installed and python2-pip is aliased as pip while python3-pip is aliased as pip3.

Make sure you are using right version with python and pip.

So the command would be:

Click to copy

pip3 install psycopg2

Answer 2

You can try

Click to copy

pip install psycopg2-binary