ImportError: No module named psycopg2 after install

Question

I've run `sudo pip install psycopg2` successfully from my `virtualenv` on my ubuntu server. This is the code I'm trying to run: ``` from flask import Flask from flask.ext.sqlalchemy import SQLAlchemy app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = "postgresql://USERNAME:PASSWORD@localhost/mydb" db = SQLAlchemy(app) app.debug = True class User(db.Model): __tablename__ = 'users' id = db.Column(db.Integer, primary_key = True) name = db.Column(db.String(100)) @app.route('/users/', methods = ['GET']) def users(): query = "SELECT id, name FROM users" results = User.query.from_statement(query).all() json_results = [] for result in results: d = {'id' : result.id, 'name' : result.name} json_results.append(d) res = jsonify(items=json_results) res.headers['Access-Control-Allow-Origin'] = '*' return res ``` however, when running uWSGI with this file like this :`uwsgi --socket 127.0.0.1:8080 --wsgi-file my_app.py --callable app --processes 4 --threads 2 --stats 127.0.0.1:9191`, and c…

Accepted Answer

The problem is that you installed psycopg2 as a superuser, i.e. using 'sudo'. When you run commands as a super user, the command gets executed in a different shell that has the superuser's environment, and as a result the package will be installed in a different location in the filesystem that may not be accessible to your 'normal' environment. You need to install the package again as a regular user, i.e. without the leading 'sudo' in order to use the package. In short, just run:

```
pip install psycopg2
```

ImportError: No module named psycopg2 after install

Solution

Problem