[Django]-Install libpq-dev on Mac OS X

For OSX 10.9.2 Mavericks, this is what worked for me. Try installing postgres with brew first:

brew install postgresql

Then install pg

gem install pg

So I ended up following the advice here:

http://blog.jonypawks.net/2008/06/20/installing-psycopg2-on-os-x/

Turns out I did have pg-config installed, but I had to dig around to find it a bit. Once I included that in the path, everything worked swimmingly. Here’s the snippet from that link:

PATH=$PATH:/Library/PostgresPlus/8.3/bin/ sudo easy_install psycopg2

I used pip instead of easy_install and my PostgreSQL installation directory was slightly different, but that’s the gist.

Just install postgres from source. I’m doing that on Mac OS X. It’s as easy as:

./configure 
make
sudo make install

Of course you may need extra steps like autostarting, or setting configure options, but I belive this is still most painless way of setting up on Mac OS X.

And if you for some reason want to avoid installing from source, you should look for a binary version of psycopg2, e.g. here: http://www.initd.org/psycopg/download/

sudo port install py27-psycopg2

In postgress.app on mavericks the file pg_config is in /Applications/Postgres.app/Contents/MacOS/bin/ so i fixed the problem in this way:

sudo PATH=$PATH:/Applications/Postgres.app/Contents/MacOS/bin/ pip install psycopg2

Using macports, this worked for me:

sudo port install postgresql96
sudo port select --set postgresql postgresql96

I believe this installs all the postgres client tools and libs, while macports has a separate port for installing the server, i.e. postgresql96-server.

If you’re just trying to install psycopg2 to run on a mac for Django or Flask etc. then use:

pip install psycopg2-binary

From the docs https://www.psycopg.org/docs/install.html