ImportError: No module named psycopg2, warnings displayed during install

I'm running Python 2.7 on Windows 7 64 bit. After installing this package through pip, I still don't have psycopg2 installed in the virtualenv (module can't be found). Looking in the Lib/site-packages folder after installing, I have a folder named "psycopg2-2.5.2-py2.7.egg-info" containing the following files:

dependency_links.txt
installed-files.txt
PKG-INFO
SOURCES.txt
top_level.txt

I've attached the pip install output below.

E:\devlink\python\pgtest>Scripts\pip.exe -v -v -v install git+https://github.com
/nwcell/psycopg2-windows.git@win64-py27#egg=psycopg2
Downloading/unpacking psycopg2 from git+https://github.com/nwcell/psycopg2-windo
ws.git@win64-py27
Cloning https://github.com/nwcell/psycopg2-windows.git (to win64-py27) to e:\d
evlink\python\pgtest\build\psycopg2
Found command 'git' at 'D:\Program Files (x86)\Git\cmd\git.exe'
Running command "D:\Program Files (x86)\Git\cmd\git.exe" clone -q https://gith
ub.com/nwcell/psycopg2-windows.git E:\devlink\python\pgtest\build\psycopg2
Running command "D:\Program Files (x86)\Git\cmd\git.exe" show-ref
(Omitted Git logs)
Running command "D:\Program Files (x86)\Git\cmd\git.exe" rev-parse HEAD
5698844
Running command "D:\Program Files (x86)\Git\cmd\git.exe" checkout -q 9248495
a04d00895986e9161f945330ceb190d
Running setup.py (path:E:\devlink\python\pgtest\build\psycopg2\setup.py) egg_i
nfo for package psycopg2
Running command python setup.py egg_info
running egg_info
creating pip-egg-info\psycopg2.egg-info
writing pip-egg-info\psycopg2.egg-info\PKG-INFO
writing top-level names to pip-egg-info\psycopg2.egg-info\top_level.txt
writing dependency_links to pip-egg-info\psycopg2.egg-info\dependency_links.
txt
writing manifest file 'pip-egg-info\psycopg2.egg-info\SOURCES.txt'
D:\Python27\Lib\distutils\dist.py:267: UserWarning: Unknown distribution opt
ion: 'summary'
warnings.warn(msg)
warning: manifest_maker: standard file '-c' not found

reading manifest file 'pip-egg-info\psycopg2.egg-info\SOURCES.txt'
writing manifest file 'pip-egg-info\psycopg2.egg-info\SOURCES.txt'

Source in e:\devlink\python\pgtest\build\psycopg2 has version 2.5.2, which sat
isfies requirement psycopg2 from git+https://github.com/nwcell/psycopg2-windows.
git@win64-py27
Installing collected packages: psycopg2
Running setup.py install for psycopg2
Running command E:\devlink\python\pgtest\Scripts\python.exe -c "import setup
tools, tokenize;file='E:\devlink\python\pgtest\build\psycopg2\setup.py
';exec(compile(getattr(tokenize, 'open', open)(file).read().replace('\r\n',
'\n'), file, 'exec'))" install --record c:\users\admin\appdata\local\temp\pi
p-_cqnrn-record\install-record.txt --single-version-externally-managed --compile
--install-headers E:\devlink\python\pgtest\include\site\python2.7
running install
running build
running install_egg_info
running egg_info
creating psycopg2.egg-info
writing psycopg2.egg-info\PKG-INFO
writing top-level names to psycopg2.egg-info\top_level.txt
writing dependency_links to psycopg2.egg-info\dependency_links.txt
writing manifest file 'psycopg2.egg-info\SOURCES.txt'
D:\Python27\Lib\distutils\dist.py:267: UserWarning: Unknown distribution opt
ion: 'summary'
warnings.warn(msg)
warning: manifest_maker: standard file '-c' not found

reading manifest file 'psycopg2.egg-info\SOURCES.txt'
writing manifest file 'psycopg2.egg-info\SOURCES.txt'
Copying psycopg2.egg-info to E:\devlink\python\pgtest\Lib\site-packages\psyc

opg2-2.5.2-py2.7.egg-info
running install_scripts
writing list of installed files to 'c:\users\admin\appdata\local\temp\pip-_c
qnrn-record\install-record.txt'
Successfully installed psycopg2
Cleaning up...
Removing temporary dir E:\devlink\python\pgtest\build...

[radeksvarz]

The same error for WIN32 python 2.7.
I used the workaround of downloading the appropriate branch from git and copying the folder psycopg2 into the site-packages.
Then it worked.

[H0R5E]

Same issue, py2.7 win64. I suggest adding this to the setup.py script:

from setuptools import find_packages

setup(
    ....
    packages=find_packages("."),
    ...
)

@H0R5E
Send the author a pull request, that might wake him up ;)

[chiefy]

👍 also just hit this issue.

[fredrikaverpil]

I hit this issue as well. I followed the instructions posted by @radeksvarz and now it works. It did not help to add the code to the setup.py suggested by @H0R5E

[monostop]

Same issue, same workaround as @radeksvarz works.

[H0R5E]

@fredrikaverpil sorry, yes, you need to include the compiled pyd library as well. So the updated setup.py has the following lines:

from distutils.core import setup
from setuptools import find_packages

setup(
    name='psycopg2',

    ...

    packages=find_packages("."),
    package_data={'psycopg2': ['*.pyd']},

    ...

    )

I have a working version for python 2.7 win64 here and for win32 here.

[autoferrit]

I am having the same errors on windows 8 x64 with postgres 9.4 and python 3.4. I tried cloning the repo and checkout the appropriate branch and copying the psycopg directory into site-packages, but I still got the errors. I also tried what @H0R5E mentioned with the setup script but couldnt get it to run.

[vgarciainfante]

Hi, i had installed postgres 9.3 and python 3.4 and Psycopg2, but when i type:
import Psycopg2
importError : No module named 'Psycopg2'

[Sharadh]

Had same issue. Workaround suggested didn't work. Ended up using the MSI installer from http://www.stickpeople.com/projects/python/win-psycopg/

To rephrase what other comments have said: (In Python34/Lib/site-packages/) The pip command installs the psycopg2*.egg folder, but does not create the actual psycopg2 module's folder. I.e, download is OK, installation is not.

[zrisher]

Same issue. As @Sharadh mentioned I installed the .msi and moved the files in - voila, success. I've been struggling with this for a couple days and this was the only solution, have tried everything listed on SO, google, and this thread. Between silent fails and C compilation reflection issues, this was a gigantic hassle. If only this repo was working, I totally agree with Every time I need to set up psycopg2 on windows, I wind up wanting to shoot something.

[walkerdb]

Same issue, Windows 8.1, python 3.4.2. The pip install only seems to add the .egg folder, but then gives a "success" message. Trying to import the module fails.

[bhatt40]

Same issue, Windows 7 with python 2.7.9. I used the .msi to install it to my base python installation, then copied the whole directory into the lib/site-packages directory of my virtual environment. That worked.

[danhamill]

I found @Sharadh solution worked for me. I installed the .msi from http://www.stickpeople.com/projects/python/win-psycopg/ and the import was successful. I am on win 7 64 bit machine.