Installing the psycopg2 pip package into a venv on Arch Linux, arch package postgresql-libs is required
psycopg2
postgresql-libs
To install the package:
pacman -S postgresql-libs