#14604: Ubuntu documentation for geospatial/Postgres is out of date
------------------------------------+---------------------------------------
Reporter: mfitzp | Owner: nobody
Status: new | Milestone:
Component: Documentation | Version: 1.2
Resolution: | Keywords: gis
Stage: Accepted | Has_patch: 0
Needs_docs: 0 | Needs_tests: 0
Needs_better_patch: 0 |
------------------------------------+---------------------------------------
Changes (by gabrielhurley):
* needs_better_patch: => 0
* needs_tests: => 0
* keywords: => gis
* needs_docs: => 0
* stage: Unreviewed => Accepted
Old 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
New 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`
Comment:
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".
--
Ticket URL: <http://code.djangoproject.com/ticket/14604#comment:1>
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.
