ImportError: No module named psycopg2

Question

In installation process of OpenERP 6, I want to generate a config file with these commands:

cd /home/openerp/openerp-server/bin/ 

./openerp-server.py -s --stop-after-init -c /home/openerp/openerp-server.cfg 

But it always showed the message: ImportError: No module named psycopg2

When I checked for psycopg2 package, it's already installed. Package python-psycopg2-2.4.5-1.rhel5.x86_64 is already installed to its latest version. Nothing to do. What's wrong with this? My server is CentOS, I've installed Python 2.6.7.

Answer 1

Step 1: Install the dependencies

sudo apt-get install build-dep python-psycopg2 

Step 2: Run this command in your virtualenv

pip install psycopg2-binary  

Ref: Fernando Munoz

Answer 2

Use psycopg2-binary instead of psycopg2.

pip install psycopg2-binary 

Or you will get the warning below:

UserWarning: The psycopg2 wheel package will be renamed from release 2.8; in order to keep installing from binary please use "pip install psycopg2-binary" instead. For details see: http://initd.org/psycopg/docs/install.html#binary-install-from-pypi.

Reference: Psycopg 2.7.4 released | Psycopg