Skip to content Skip to sidebar Skip to footer
Home / Django / Postgresql / Psycopg2 / Python

Importerror: Dll Load Failed : - When Trying To Import Psycopg2 Library

Post a Comment
>>> import psycopg2 Traceback (most recent call last): File '', line 1, in File 'C:\Python26\lib\site-packages\psycopg2\__init__.py', line 60, in from _psycopg

Solution 1:

On Windows, make sure your path includes the Postgres bin directory. In my machine it's c:\Programs\PostgreSQL\9.3\bin.

Solution 2:

According to this thread you need to install an earlier version since there were problems with the latest build.

Simply install an earlier version, (2.0.10 works great), even with PostgreSQL 8.4.x series.

Solution 3:

You can also try installing win-psycopg from here

Solution 4:

Try to run the following command:

pip install psycopg2-binary

Solution 5:

It is a problem with virtualenv and psycopg2. I have copied _psycopg.cp38-win_amd64.pyd from global python to \venv\Lib\site-packages\psycopg2 This worked for me.

Post a Comment for "Importerror: Dll Load Failed : - When Trying To Import Psycopg2 Library"