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 14 years, 9 months ago
  2. Drop all tables in MySQL database by mpasternacki 15 years, 3 months ago
  3. grep and delete sqlite tables by kifkif 15 years, 5 months ago
  4. Substitute hyphens with spaces to enale URLs to reference to multi-word tags by miernik 15 years, 6 months ago
  5. oneliner to delete SQLite tables by kifkif 15 years, 6 months ago

Comments

Please login first before commenting.