Skip to content

Instantly share code, notes, and snippets.

@cadu-leite

cadu-leite/gist:8236f4c16dc756eb1eb578784b9bdd5e

Forked from joshuapowell/gist:e209a4dac5c8187ea8ce
Created September 7, 2020 21:45
Show Gist options
  • Save cadu-leite/8236f4c16dc756eb1eb578784b9bdd5e to your computer and use it in GitHub Desktop.
Save cadu-leite/8236f4c16dc756eb1eb578784b9bdd5e to your computer and use it in GitHub Desktop.
Download ZIP
Setup Postgres.app to use PostGIS on OS X
Raw
gistfile1.md

Download and Install Postgres.app

Before we can setup PostGIS we need to have a local version of Postgresql installed and running. The most effecient way to do this is to download and install Postgres.app.

Spatially Enable your Postgres Database

Once Postgres.app is installed in your computers /Applications directory. Open the Terminal and enter the following two commands

psql -d DATABASE_NAME -f /Applications/Postgres.app/Contents/Versions/9.3/share/postgresql/contrib/postgis-2.1/postgis.sql

psql -d DATABASE_NAME -f /Applications/Postgres.app/Contents/Versions/9.3/share/postgresql/contrib/postgis-2.1/spatial_ref_sys.sql

Notes

Remember, this must be done on a database by database scale and this example does not accomodate multiple databases.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment