OS X PostGIS install.rst

Prerequisites

• Download and install FreeType, GDAL Complete, Postgres and PostGIS from http://www.kyngchaos.com/software:postgres and http://www.kyngchaos.com/software:frameworks
• Add /usr/local/pgsql/bin to $PATH

Project Specific Setup

Setting up a new virtualenv

• pip install psycopg2

Setting up a new database

This process recently:

sudo -H -u postgres createuser -E --pwprompt <DB_USER>
sudo -H -u postgres createdb -O <DB_USER> <DB_NAME>
sudo -H -u postgres -- /usr/local/pgsql/bin/createlang plpgsql <DB_NAME>
sudo -H -u postgres -- psql -d <DB_USER> -f /usr/local/pgsql/share/contrib/postgis.sql
sudo -H -u postgres -- psql -d <DB_USER> -f /usr/local/pgsql/share/contrib/spatial_ref_sys.sql