Opened 14 years ago

Closed 14 years ago

Last modified 13 years ago

#14604 closed (fixed)

Ubuntu documentation for geospatial/Postgres is out of date

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 (last modified by Gabriel Hurley)

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

Attachments (1)

create_template_postgis-debian.sh (673 bytes ) - added by mfitzp 14 years ago.
updated script

Download all attachments as: .zip

Change History (5)

by mfitzp, 14 years ago

updated script

comment:1 by Gabriel Hurley, 14 years ago

Description: modified (diff)
Keywords: gis added
Triage Stage: UnreviewedAccepted

Formatted description. The docs referenced by this ticket are here: http://docs.djangoproject.com/en/dev/ref/contrib/gis/install/#ibex

The whole section is outdated, not just the script. Those docs don't mention Jaunty (9.04) or Lucid (10.04) at all. Simply fixing the script isn't the answer, here, though it would help.

Also, the current sentence has a typo, and is missing the word "in".

comment:2 by Tim Graham, 14 years ago

Component: DocumentationGIS
Has patch: set

comment:3 by jbronn, 14 years ago

milestone: 1.3
Resolution: fixed
Status: newclosed

Fixed in r15536. Scripts were updated for all Ubuntu/Debian distributions and docs were updated to include instructions for latest versions of Ubuntu.

comment:4 by Jacob, 13 years ago

milestone: 1.3

Milestone 1.3 deleted

Note: See TracTickets for help on using tickets.
Back to Top