Error while install requirement for odoo17 "psycopg2"

Question

ubuntu@ip-172-26-11-98:/opt/odoo17$ sudo systemctl status odoo17.service
● odoo17.service - Odoo17
Loaded: loaded (/etc/systemd/system/odoo17.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Wed 2024-04-17 13:06:11 IST; 5s ago
Docs: db.py [1] ", line 4, in
Apr 17 13:06:11 ip-172-26-11-98 odoo-bin[1360853]:     from psycopg2.extras import Json
Apr 17 13:06:11 ip-172-26-11-98 odoo-bin[1360853]: ModuleNotFoundError: No module named 'psycopg2'
Apr 17 13:06:11 ip-172

Apiuser · Answer

In my case I was getting this error but I finally found the root of the problem, and it was because of the externally managed libraries. You can check all the discussion and answers here:
https://stackoverflow.com/questions/75608323/how-do-i-solve-error-externally-managed-environment-every-time-i-use-pip-3 [1]
What worked for me was setting this before loading the requierements (as a workaround in the suggested answer in the post I mentioned):
python3 -m pip config set global.break-system-packag

Cybrosys Techno Solutions Pvt.Ltd · Answer

Hi,Try to Install the requirement 'psycopg2-binary ' instead of psycopg2
use the below script to install the requirement
pip install psycopg2-binary

Hope it helps

This question has been flagged

Enjoying the discussion? Don't just read, join in!