id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
14604	Ubuntu documentation for geospatial/Postgres is out of date	mfitzp	nobody	"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	Documentation	1.2			gis		Accepted	0	0	0	0	0	0