#14604: Ubuntu documentation for geospatial/Postgres is out of date ---------------------------+------------------------------------------------ Reporter: mfitzp | Owner: nobody Status: new | Milestone: Component: Documentation | Version: 1.2 Keywords: | Stage: Unreviewed Has_patch: 0 | ---------------------------+------------------------------------------------ The note where it says "The PostGIS SQL files are not placed the PostgreSQL share directory in the Ubuntu packages. Use the create_template_postgis-debian.sh script instead when Creating a Spatial Database Template for PostGIS." links to an Ubuntu script which no longer works (Maverick 10.10).
The following script is functional: #!/usr/bin/env bash POSTGIS_SQL_PATH=/usr/share/postgresql/8.4/contrib/postgis-1.5 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;" Note the updated path and the renamed lwpostgis.sql > postgis.sql -- Ticket URL: <http://code.djangoproject.com/ticket/14604> Django <http://code.djangoproject.com/> The Web framework for perfectionists with deadlines. -- You received this message because you are subscribed to the Google Groups "Django updates" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-updates?hl=en.
