Opened 14 years ago
Last modified 13 years ago
#14604 closed
Ubuntu documentation for geospatial/Postgres is out of date — at Initial Version
| Reported by: | mfitzp | Owned by: | nobody |
|---|---|---|---|
| Component: | GIS | Version: | 1.2 |
| Severity: | Keywords: | gis | |
| Cc: | Triage Stage: | Accepted | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
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
updated script