Install the PostGreSQL driver, psycopg2, with Python with a Mac
Mac is a good computer but seems to be weird when you are attacking some install.
I had error installing the PostGreSQL drivers for python.
Typing a :
$ pipenv install psycopg2
$ pip install psycopg2 was leading to compilation error…
Problems seems to be with Mac (as usual) and Path. (as Usual)
Then was solved on my side doing that :
1 – I presume you have PostGreSQL installed via a homebrew install …
if not :
$ brew install postgresql
2 – I presume you have started PostGree too…
If not, :
$ pg_ctl -D /usr/local/var/postgres start
3 – Install Opensll
$ brew install openssl
If you have already installed it, re-install
$ brew reinstall openssl
4 – Find the path of pg_config
$ find / -name pg_config 2>/dev/nul
5 – Check something like my path :
$ export PATH=$PATH:/usr/local/Cellar/postgresql/11.5_1/bin/pg_config
6 – Do the same thing with the lib ssl :
$ export LIBRARY_PATH=$LIBRARY_PATH:/usr/local/opt/openssl/lib/
Ok now, you should be OK typing :
$ pipenv install psycopg2 if you use pipenv
$ pip install psycopg2
it could pip3 instead of pip if you are not working under virtual environnement and you have installed the python 3 version keeping the python2 on the Mac.
Inside a virtual environnement, the pip is linked to python3 by default.