Getting ImportError: No module named psycopg2 but the module is already installed. odoo12

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

客户关系管理
e-Commerce
会计
库存
PoS
Project
MRP

All apps

所有帖文人徽章

标签（查看所有）

odoo accounting v14 pos v15

关于此论坛区

帮助

Getting ImportError: No module named psycopg2 but the module is already installed. odoo12

xmlrpc psycopg2 python3.x odoo12

8 回复

48729 查看

Pallavi

Hi,

I am trying to install psycopg2 module. but it is giving me the error "ImportError: No module named psycopg2". and when I try to install, it's showing like "Requirement already satisfied: psycopg2 in ./.local/lib/python3.6/site-packages (2.7.4)".

and the same for xmlrpc.client it's giving the error

ERROR: Could not find a version that satisfies the requirement xmlrpclib (from versions: none)
ERROR: No matching distribution found for xmlrpclib.

Could anyone help me to resolve this error.

thanks in advance!

subbarao

try to install using pip

Pallavi

编写者

already tried with pip, pip2, pip3 but no use.

CHAREF Abdelmoula

最佳答案

I remember I've fixed this issue by uninstalling psycopg2 and installing the binary one

you can install it using these commands

sudo pip uninstall psycopg2

pip install psycopg2-binary

using Pycharm interface :

1-Ctrl+alt+s

2-search interpreter

3-on the right side of the window click on +

4-search psycopg2-binary and click install

if you still have the same problem make sure that you are using your system interpreter and not your virtualenv interpreter if you have installed the dependencies on your system

hope this helps someone,

bardcrack

Thank so much. This resolve my problem.

Zahid Mehmood

This resolves my problem too. Thank you.

HTCorps

this working ...

sudo apt-get install libpq-dev

pip install psycopg2

sudo apt-get install build-dep python-psycopg2

pip3 install psycopg2

anniesteuber

Thank you for sharing your journey with me.

anniesteuber

This is interesting https://hello-neighbor.io

Martin Col

Thank you, its so helpful!

Martin Col

what is it? https://chi-nese.com

ankemargot

Make sure you are installing the module for the correct Python version. If you are using Python 3.6, ensure you are installing it for that version specifically. Also, if you are using a virtual environment, activate it before running the installation command.

ankemargot

I forgot to mention that if you are trying to import xmlrpclib, update your code to use xmlrpc.client instead, as it's the correct module name for Python 3. Simple replace "import xmlrpclib" with "import xmlrpc.client". Of course, if your code is written for Python 2, you might need to update it to be compatible with Python 3, and this includes changing module names like in the example above.
Source: https://chi-nese.com/

isabelwaters

To solve the error, install the module by running the pip install psycopg2-binary command.

roryrry

The error message "Requirement already satisfied: psycopg2 in ./.local/lib/python3.6/site-packages (2.7.4)" indicates that the psycopg2 module is already installed in your Python environment. However, you're still getting an import error, which suggests there might be some conflict with other modules or Python versions.

roryrry

To resolve this:
- Check your virtual environment: Make sure you're trying to import psycopg2 from the active virtual environment where it's installed.
- Verify installation path: Ensure you're using the correct Python version when running pip commands. For instance, if your command prompt shows Python 3.7 while you're trying to install for Python 3.6, it might lead to conflicts.
- Re-install psycopg2: Try reinstalling the psycopg2 module using pip. This can sometimes resolve any installation issues.
Sources: https://getaway-shootout.com

ITStore

Hi pallavi,

in your system paclage is installed for python3 and and you are running odoo 13, so odoo 13 use python3.6. So in that case you need to install separate package for python3.6

can you please try bellow command:

python3.6 -m pip install PACKAGE_NAME

喜欢讨论吗？不要只阅读，加入进来！

立即创建账户，享受专属功能，与我们的精彩社区互动！

相关帖文	回复	查看
Psycopg2 error while installing odoo12 on ubuntu18 installation psycopg2 odoo12	4 6月 24	8076
What DB type to select for Odoo optimization? xmlrpc ecommerce odoo12	0 4月 20	4109
TypeError: not all arguments converted during string formatting 已解决 formatting python3.x odoo12	4 10月 19	16370
Can't affect attachments to specific records of a custom module through XML-RPC xmlrpc attachments odoo12	0 4月 19	3301
Connecting to an Odoo 16 database from Python 已解决 python database xmlrpc psycopg2	1 4月 23	8353

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！