Skip to content

Instantly share code, notes, and snippets.

@cristiangrojas

cristiangrojas/to add the postgis template:

Created June 2, 2013 00:30
Show Gist options
  • Save cristiangrojas/5692176 to your computer and use it in GitHub Desktop.
Save cristiangrojas/5692176 to your computer and use it in GitHub Desktop.
Download ZIP
to add the postgis template:
Raw
to add the postgis template:
to add the postgis template:
cd /usr/local/Cellar/postgis/2.0.0/share/postgis/
createdb -E UTF8 template_postgis
createlang -d template_postgis plpgsql
psql -d postgres -c "UPDATE pg_database SET datistemplate='true' WHERE datname='template_postgis';"
psql -d template_postgis -f postgis.sql
psql -d template_postgis -f spatial_ref_sys.sql
psql -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;"
psql -d template_postgis -c "GRANT ALL ON geography_columns TO PUBLIC;"
psql -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment