You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
778 B
19 lines
778 B
#!/bin/bash
|
|
#
|
|
# Init script for template postgis
|
|
#
|
|
|
|
POSTGIS_SQL_PATH=`pg_config --sharedir`/contrib/postgis-2.2;
|
|
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 -c "CREATE EXTENSION postgis;"
|
|
psql -d template_postgis -c "CREATE EXTENSION postgis_topology;"
|
|
psql -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;"
|
|
psql -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"
|
|
psql -c "CREATE EXTENSION plpythonu;"
|
|
psql -d template_postgis -c "CREATE EXTENSION plpythonu;"
|
|
psql -d template_postgis -c "CREATE EXTENSION crankshaft VERSION 'dev';"
|
|
psql -d template_postgis -c "CREATE EXTENSION plproxy;"
|