How to install psycopg2 with "pip" on Python?
Note: Since a while back, there are binary wheels for Windows in PyPI, so this should no longer be an issue for Windows users. Below are solutions for Linux, Mac users, since lots of them find this post through web searches.
psycopg2-binary PyPI package instead, it has Python wheels for Linux and Mac OS.
pip install psycopg2-binary
Install the prerequsisites for building the
psycopg2 package from source:
sudo apt install libpq-dev python3-dev
You might need to install
python3.8-dev or similar for e.g. Python 3.8.
sudo apt install libpq-dev python-dev
If that's not enough, try
sudo apt install build-essential
sudo apt install postgresql-server-dev-all
as well before installing psycopg2 again.
See Banjer's answer
1 Really? It's 2021