*** postgis.xml.orig Wed Oct 11 12:42:22 2006
--- postgis.xml Wed Oct 11 12:49:26 2006
***************
*** 361,366 ****
--- 361,379 ----
+
+ Creating PostGIS spatially-enabled databases from an in-built template
+ Some packaged distributions of PostGIS (in particular the Win32 installers for PostGIS >= 1.1.5) load the PostGIS functions into a template database called template_postgis. If the template_postgis database exists in your PostgreSQL installation then it is possible for users and/or applications to create spatially-enabled databases using a single command. Note that in both cases, the database user must have been granted the privilege to create new databases.
+
+ From the shell:
+
+ # createdb -T template_postgis my_spatial_db
+
+ From SQL:
+
+ postgres=# CREATE DATABASE my_spatial_db TEMPLATE=template_postgis
+
+
Upgrading