No module named psycopg2 как исправить

A common error you may encounter when using Python is modulenotfounderror: no module named ‘psycopg2’.

This error occurs when the Python interpreter cannot detect the Psycopg library in your current environment.

You can install Psycopg2 in Python 3 with python3 -m pip install psycopg2-binary.

This tutorial goes through the exact steps to troubleshoot this error for the Windows, Mac and Linux operating systems.

ModuleNotFoundError: no module named ‘psycopg2’

What is ModuleNotFoundError?

The ModuleNotFoundError occurs when the module you want to use is not present in your Python environment. There are several causes of the modulenotfounderror:

The module’s name is incorrect, in which case you have to check the name of the module you tried to import. Let’s try to import the re module with a double e to see what happens:

import ree

---------------------------------------------------------------------------
ModuleNotFoundError                       Traceback (most recent call last)
1 import ree

ModuleNotFoundError: No module named 'ree'

To solve this error, ensure the module name is correct. Let’s look at the revised code:

import re

print(re.__version__)

2.2.1

You may want to import a local module file, but the module is not in the same directory. Let’s look at an example package with a script and a local module to import. Let’s look at the following steps to perform from your terminal:

mkdir example_package

cd example_package

mkdir folder_1

cd folder_1

vi module.py

Note that we use Vim to create the module.py file in this example. You can use your preferred file editor, such as Emacs or Atom. In module.py, we will import the re module and define a simple function that prints the re version:

import re

def print_re_version():

    print(re.__version__)

Close the module.py, then complete the following commands from your terminal:

cd ../

vi script.py

Inside script.py, we will try to import the module we created.

import module

if __name__ == '__main__':

    mod.print_re_version()

Let’s run python script.py from the terminal to see what happens:

Traceback (most recent call last):
  File "script.py", line 1, in ≺module≻
    import module
ModuleNotFoundError: No module named 'module'

To solve this error, we need to point to the correct path to module.py, which is inside folder_1. Let’s look at the revised code:

import folder_1.module as mod

if __name__ == '__main__':

    mod.print_re_version()

When we run python script.py, we will get the following result:

2.2.1

Lastly, you can encounter the modulenotfounderror when you import a module that is not installed in your Python environment.

What is Psycopg2?

Psycopg2 is a PostgreSQL database adapter for Python. It provides an API to connect to an external database.

The simplest way to install psycopg2 is to use the package manager for Python called pip. The following installation instructions are for the major Python version 3.

Always Use a Virtual Environment to Install Packages

It is always best to install new libraries within a virtual environment. You should not install anything into your global Python interpreter when you develop locally. You may introduce incompatibilities between packages, or you may break your system if you install an incompatible version of a library that your operating system needs. Using a virtual environment helps compartmentalize your projects and their dependencies. Each project will have its environment with everything the code needs to run. Most ImportErrors and ModuleNotFoundErrors occur due to installing a library for one interpreter and trying to use the library with another interpreter. Using a virtual environment avoids this. In Python, you can use virtual environments and conda environments. We will go through how to install psycopg2 with both.

How to Install Psycopg2 on Windows Operating System

First, you need to download and install Python on your PC. Ensure you select the install launcher for all users and Add Python to PATH checkboxes. The latter ensures the interpreter is in the execution path. Pip is automatically on Windows for Python versions 2.7.9+ and 3.4+.

You can check your Python version with the following command:

python3 --version

You can install pip on Windows by downloading the installation package, opening the command line and launching the installer. You can install pip via the CMD prompt by running the following command.

python get-pip.py

You may need to run the command prompt as administrator. Check whether the installation has been successful by typing.

pip --version

Psycopg2 installation on Windows Using pip

To install psycopg2, first create the virtual environment. The environment can be any name, in this we choose “env”:

virtualenv env

You can activate the environment by typing the command:

envScriptsactivate

You will see “env” in parenthesis next to the command line prompt. You can install psycopg2 within the environment by running the following command from the command prompt.

python3 -m pip install psycopg2-binary

We use python -m pip to execute pip using the Python interpreter we specify as Python. Doing this helps avoid ImportError when we try to use a package installed with one version of Python interpreter with a different version. You can use the command which python to determine which Python interpreter you are using.

How to Install Psycopg2 on Mac Operating System using pip

Open a terminal by pressing command (⌘) + Space Bar to open the Spotlight search. Type in terminal and press enter. To get pip, first ensure you have installed Python3:

python3 --version

Python 3.8.8

Download pip by running the following curl command:

curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py

The curl command allows you to specify a direct download link. Using the -o option sets the name of the downloaded file.

Install pip by running:

python3 get-pip.py

To install psycopg2, first create the virtual environment:

python3 -m venv env

Then activate the environment using:

source env/bin/activate 

You will see “env” in parenthesis next to the command line prompt. You can install psycopg2 within the environment by running the following command from the command prompt.

python3 -m pip install psycopg2-binary

How to Install Psycopg2 on Linux Operating Systems

All major Linux distributions have Python installed by default. However, you will need to install pip. You can install pip from the terminal, but the installation instructions depend on the Linux distribution you are using. You will need root privileges to install pip. Open a terminal and use the commands relevant to your Linux distribution to install pip.

Installing pip for Ubuntu, Debian, and Linux Mint

sudo apt install python-pip3

Installing pip for CentOS 8 (and newer), Fedora, and Red Hat

sudo dnf install python-pip3

Installing pip for CentOS 6 and 7, and older versions of Red Hat

sudo yum install epel-release

sudo yum install python-pip3

Installing pip for Arch Linux and Manjaro

sudo pacman -S python-pip

Installing pip for OpenSUSE

sudo zypper python3-pip

Psycopg2 installation on Linux with Pip

To install psycopg2, first create the virtual environment:

python3 -m venv env

Then activate the environment using:

source env/bin/activate 

You will see “env” in parenthesis next to the command line prompt. You can install psycopg2 within the environment by running the following command from the command prompt.

Once you have activated your virtual environment, you can install psycopg2 using:

python3 -m pip install psycopg2-binary

Installing Psycopg2 Using Anaconda

Anaconda is a distribution of Python and R for scientific computing and data science. You can install Anaconda by going to the installation instructions. Once you have installed Anaconda, you can create a virtual environment and install psycopg2.

To create a conda environment you can use the following command:

conda create -n psycopg2 python=3.8

You can specify a different Python 3 version if you like. Ideally, choose the latest version of Python. Next, you will activate the project container. You will see “psycopg2” in parentheses next to the command line prompt.

source activate psycopg2

Now you’re ready to install psycopg2 using conda.

Once you have activated your conda environment, you can install psycopg2 using the following command:

conda install -c anaconda psycopg2

Check Psycopg2 Version

Once you have successfully installed psycopg2, you can check its version. If you used pip to install psycopg2, you can use pip show from your terminal.

python3 -m pip show psycopg2-binary

Name: psycopg2-binary
Version: 2.9.3
Summary: psycopg2 - Python-PostgreSQL Database Adapter

Second, within your python program, you can import psycopg2 and then reference the __version__ attribute:

import psycopg2
print(psycopg2.__version__)

2.9.3

If you used conda to install psycopg2, you could check the version using the following command:

conda list -f psycopg2

# Name                    Version                   Build  Channel
psycopg2                  2.8.5            py38hddc9c9b_0    anaconda

Summary

Congratulations on reading to the end of this tutorial. The modulenotfounderror occurs if you misspell the module name, incorrectly point to the module path or do not have the module installed in your Python environment. If you do not have the module installed in your Python environment, you can use pip to install the package. However, you must ensure you have pip installed on your system. You can also install Anaconda on your system and use the conda install command to install psycopg2.

Go to the online courses page on Python to learn more about Python for data science and machine learning.

For further reading on missing modules in Python, go to the article:

• How to Solve Python ModuleNotFoundError: no module named ‘urllib2’.
• How to Solve ModuleNotFoundError: no module named ‘plotly’.
• How to Solve Python ModuleNotFoundError: no module named ‘boto3’.

Have fun and happy researching!

Hi all, First of all, I’ve read all the posts I could find about this problem to no avail 🙁

I’ve got an up&running default webapp with python3 and django already working with default db.sqlite2. I now need to change all the db backend to psql.

So, from these sources:

https://pypi.org/project/psycopg2/
https://www.psycopg.org/docs/install.html

I’ve installed psycopg2-binary, OK. Then, from this source:

https://www.enterprisedb.com/postgres-tutorials/how-use-postgresql-django

I’ve modified settings.py, DATABASES section, to use psql instead of sqlite. I’ve tried:

'ENGINE': 'django.db.backends.postgresql_psycopg2',

and it failed. Then, from some youtube videos, I tried:

'ENGINE': 'django.db.backends.postgresql',

which also fails… The error is this one, when I try to make migrations:

(env) PS D:Usersllagos.NB-KEYONE15Visual Studio projectsecommerce-psql> python manage.py makemigrations
Traceback (most recent call last):
File “D:Usersllagos.NB-KEYONE15Visual Studio projectsecommerce-psqlenvlibsite-packagesdjangodbbackendspostgresqlbase.py”, line 25, in
import psycopg2 as Database
ModuleNotFoundError: No module named ‘psycopg2’
…
django.core.exceptions.ImproperlyConfigured: Error loading psycopg2 module: No module named ‘psycopg2’
So, what’s wrong with this settings.py file? is this correct? I’ve tried to google for information but again, no luck. Documentation for psycopg2 doesn’t say what to change on settings.py. It just say “install and code”, but when using django, there are previous steps, like this settings.py file.

My env:

(env) PS D:Usersllagos.NB-KEYONE15Visual Studio projectsecommerce-psql> pip freeze
asgiref==3.3.4
astroid==2.5.6
colorama==0.4.4
Django==3.2.2
isort==5.8.0
lazy-object-proxy==1.6.0
mccabe==0.6.1
psycopg2-binary==2.8.6
pylint==2.8.2
pylint-django==2.4.4
pylint-plugin-utils==0.6
pytz==2021.1
sqlparse==0.4.1
toml==0.10.2
wrapt==1.12.1
(env) PS D:Usersllagos.NB-KEYONE15Visual Studio projectsecommerce-psql>

So far, those are all my changes… Again, this is happily working with default dblite. I just installed the module, and modified the settings file.

Thanks a lot for any hint!

Regards,

Psycopg2 is one of the most used PostgreSQL modules in Python. It is an extremely secure, efficient way to connect to PostgreSQL and use SQL queries, database operations. However, sometimes people experience an error while importing the module: no module named ‘psycopg2’, even if it has already been installed. In a previous article, we have also talked about fixing the no module named ‘plotly’ error, this article is on a similar note.

One of the ways to fix this error is by installing libpq-dev package which is required for the installation of psycopg2. If that doesn’t work, it may be that you are missing some build dependencies which can be installed using a simple sudo command. I also have a third solution for you, so let us walk through all of these one by one.

The complete error message

Before we start, here is what the complete error message may look like for you:

ImportError: No module named 'psycopg2'

OR

ModuleNotFoundError: No module named 'psycopg2'

The reason for both errors may or may not be the same, but the fixes I will be showing you in this article will work for both versions of the error.

Why (and when) does this error occur?

This error occurs while either importing psycopg2 module, or while doing something that requires the importing of the module. For example, a lot of people see the error while installing OpenERP because OpenERP tries to import the module during its installation.

The error can occur due to multiple reasons, but most of the time it’s because of:

1. Either missing PostreSQL binaries and headers (i.e. libpq-dev package)
2. Or because you don’t have the build dependencies.

It is not clear which one of the fixes may work for you (it depends on a number of things), so you have to try all of the three fixes one by one and one of these will do the trick for you.

Solution 1: Install libpq-dev package

This is the most basic solution and the one that should be tried before anything else. Basically, libpq-dev package is required if you are trying to install ‘psycopg2’. So to install the lippq-dev package, follow the steps below.

Run the following command:

sudo apt-get update -y

And then, run:

sudo apt-get install -y libpq-dev

The above commands will install a minimum set of PostgreSQL binaries and headers, which is required here.

After you have installed libpq-dev package, try one of the following commands to install psycopg2:

pip install psycopg2

OR

pip install psycopg2-binary

OR

easy_install psycopg2

In some cases, it will tell you that the module has already been installed/show you an error. However, if it doesn’t, and Python installs the module for you – then bingo! This will have fixed the no module named ‘psycopg2’ error for you.

But if it did tell you that the module was already there/showed an error, then no worries. Try one of the solutions below.

Solution 2: Install dependencies

Install build dependencies using one of the commands below:

sudo apt-get install build-dep python-psycopg2

OR

sudo apt-get install python-psycopg2

One of the two commands above should do it for you. After you have done this, try installing psycopg2 again:

pip install psycopg2

OR

pip install psycopg2-binary

OR

easy_install psycopg2

And that’s it! I hope this solution worked for you. If it didn’t, here is one last set of commands that you can try.

Solution 3: Few more commands

sudo apt-get install python-psycopg2

OR

sudo pip install psycopg2

OR

sudo apt-get install python3-psycopg2

Try using one of the above commands to install psycopg2, it may work for you. By the way, since we have been using sudo commands throughout the tutorial – it will only work on Linux terminals. I’m sure you knew that though.

We hope one of the three solutions fixed no module named ‘psycopg2’ error for you!

The Conclusion

I couldn’t find a single proper article on how to fix importerror: no module named ‘psycopg2’, so I realized that I’ll have to write one myself. You should have the same attitude – take the charge yourself whenever needed, and do not wait for others to do it for you. Stackoverflow helped me quite a bit while writing this, and I’m thankful for that. Forums are amazing, aren’t they? It’s beautiful to look at so many people helping each other.

And I hope I was able to help you too! You can return the favor by bookmarking our site or sharing it with your friends. Thank you, I wish you an amazing day ahead.

I’m attaching a very helpful YouTube video that I came across while researching for this article below.

httpv://www.youtube.com/watch?v=embed/ir9CcN7Nkfs