Skip to content

Instantly share code, notes, and snippets.

@robcowie
Created August 24, 2012 11:08
Show Gist options
  • Save robcowie/3449216 to your computer and use it in GitHub Desktop.
Save robcowie/3449216 to your computer and use it in GitHub Desktop.
Install PostGIS 2.0

Install postgresql and postgis

brew install postgresql postgis

Create a GIS-enabled db

psql -d {db} -c "CREATE EXTENSION postgis;"
psql -d {db} -c "CREATE EXTENSION postgis_topology;"

If this fails, check postgis extensions are available with

SELECT * FROM pg_available_extensions;

To see PostGIS version

SELECT PostGIS_full_version();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment