- 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
- PostgreSQL fulltext with language translations by diverman 13 years, 3 months ago
- Drop all tables in MySQL database by mpasternacki 13 years, 10 months ago
- grep and delete sqlite tables by kifkif 13 years, 11 months ago
- Substitute hyphens with spaces to enale URLs to reference to multi-word tags by miernik 14 years ago
- oneliner to delete SQLite tables by kifkif 14 years, 1 month ago
Comments
Please login first before commenting.