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