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
14241	instructions for creating spatial database template differ on fedora 13 (64 bit)	josdekloe	nobody	"Creating a Spatial Database Template for PostGIS on a 64-bit Fedora 13 machine is slightly different from what is explained on [[BR]]
http://docs.djangoproject.com/en/dev/ref/contrib/gis/install/#spatialdb-template

This list of commands eventually did the trick for me:
(note the different POSTGIS_SQL_PATH pathname, and the addition of '-64' to the postgis.sql filename)

setenv POSTGIS_SQL_PATH /usr/share/pgsql/contrib[[BR]]
# Creating the template spatial database.[BR]]
createdb -E UTF8 template_postgis[[BR]]
createlang -d template_postgis plpgsql # Adding PLPGSQL language support.[[BR]]
# Allows non-superusers the ability to create from this template[[BR]]
psql -d postgres -c ""UPDATE pg_database SET datistemplate='true' WHERE datname='template_postgis';""[[BR]]
# Loading the PostGIS SQL routines[[BR]]
psql -d template_postgis -f $POSTGIS_SQL_PATH/postgis-64.sql[[BR]]
psql -d template_postgis -f $POSTGIS_SQL_PATH/spatial_ref_sys.sql[[BR]]
# Enabling users to alter spatial tables[[BR]]
psql -d template_postgis -c ""GRANT ALL ON geometry_columns TO PUBLIC;""[[BR]]
psql -d template_postgis -c ""GRANT ALL ON geography_columns TO PUBLIC;""[[BR]]
psql -d template_postgis -c ""GRANT ALL ON spatial_ref_sys TO PUBLIC;""[[BR]]
"	New feature	closed	Documentation	1.2	Normal	wontfix	fedora		Accepted	0	0	0	0	0	0