Login

create_template_postgis-ubuntu_lucid

Author:
clawlor
Posted:
September 15, 2010
Language:
SQL
Version:
Not specified
Score:
2 (after 2 ratings)

The template creation script referenced here doesn't work on Ubuntu Lucid, where the default PostgreSQL version is now 8.4 and some things have been moved around. I've edited the script to work on Ubuntu Lucid.

1
2
3
4
5
6
7
8
9
#!/bin/bash
POSTGIS_SQL_PATH=/usr/share/postgresql/8.4/contrib
createdb -E UTF8 template_postgis # Create the template spatial database.
createlang -d template_postgis plpgsql # Adding PLPGSQL language support.
psql -d postgres -c "UPDATE pg_database SET datistemplate='true' WHERE datname='template_postgis';"
psql -d template_postgis -f $POSTGIS_SQL_PATH/postgis.sql # Loading the PostGIS SQL routines
psql -d template_postgis -f $POSTGIS_SQL_PATH/spatial_ref_sys.sql
psql -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;" # Enabling users to alter spatial tables.
psql -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"

More like this

  1. PostgreSQL fulltext with language translations by diverman 13 years, 7 months ago
  2. Drop all tables in MySQL database by mpasternacki 14 years, 1 month ago
  3. grep and delete sqlite tables by kifkif 14 years, 3 months ago
  4. Substitute hyphens with spaces to enale URLs to reference to multi-word tags by miernik 14 years, 4 months ago
  5. oneliner to delete SQLite tables by kifkif 14 years, 5 months ago

Comments

Please login first before commenting.