Login

create_template_postgis-ubuntu_lucid

Author:
clawlor
Posted:
September 15, 2010
Language:
SQL
Version:
Not specified
Tags:
postgis ubuntu
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. Simple login script from a nub by alandelevie 6 years, 7 months ago
  2. Complete Persian DateTime Widget by serj1975 3 years, 8 months ago
  3. Upload, Progressbar with sessions by revolunet 6 years, 11 months ago
  4. Login + logout script from a nub by alandelevie 6 years, 7 months ago
  5. djangoskel by ickewa 7 years, 4 months ago

Comments

Please login first before commenting.