psycopg2 not found by django after installing in virtualenv

Question

I want to use postgresql with django so did the following:

sudo apt-get install libpq-dev python-dev
sudo apt-get update
workon myenv
sudo pip install psycopg2

And after configuring my settings.py correctly, I run

./manage.py syncdb

But an exception gets thrown:

django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 module: No module named psycopg2

The database configuration:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql_psycopg2',
        'NAME': 'mydb',
        'USER': 'postgres',
        'PASSWORD': 'password1234',
        'HOST': 'localhost',
        'PORT': '',
    }
}

Also can you confirm that you installed `psycopg2` (and not `psycpg2`) with pip. — xofer, Aug 12 '14 at 15:43

score 4 · Accepted Answer · answered Aug 14 '14 at 13:50

4

Installing with sudo (sudo pip install ...) causes the installed files to be owned by root, and Django (run without sudo) cannot read them. You can sudo pip uninstall psycopg2 and then install without sudo. (If that doesn't work, try sudo chown -R $USER ~/.virtualenvs/myvenv first (assumes that's your virtualenv path).

answered Aug 14 '14 at 13:50

xofer

3,052
12
19

2

you are my savior – You knows who Dec 16 '14 at 19:16

psycopg2 not found by django after installing in virtualenv

1 Answers1