Creating a PostGIS template

来源：百度文库编辑：神马文学网时间：2024/04/28 18:06:48

The following is adapted from Rob Braswell’s instructions. This allows non-superusers to create spatial databases using a template.

Connect to the template database
$ psql template1
Execute the following commands:
template1=# create database template_postgis with template = template1;
template1=# UPDATE pg_database SET datistemplate = TRUE where datname = 'template_postgis';
Connect to the new template_postgis database:
template1=# \c template_postgis
Add PostGIS extensions and grant access to everyone to spatial tables:
template_postgis=# CREATE LANGUAGE plpgsql;
template_postgis=# \i /opt/local/share/postgis/lwpostgis.sql;
template_postgis=# \i /opt/local/share/postgis/spatial_ref_sys.sql;
template_postgis=# GRANT ALL ON geometry_columns TO PUBLIC;
template_postgis=# GRANT ALL ON spatial_ref_sys TO PUBLIC;
Prevent further modifications to the template_postgis database:
template_postgis=# VACUUM FREEZE;
Quit out of psql (^D or \q)
Create a test database using the new template_postgis template…
$ createdb test_gis_db -T template_postgis
…and drop it again.
$ dropdb test_gis_db

Creating a PostGIS template 1.2. Part 2: Creating a Template Selector Creating a Personalization Portal Creating a Windows DLL with Visual Basic Creating a Simple Web Application in NetBeans... Creating a custom CursorAdapter for ListView ... Creating a private UDDI to find and invoke a service Creating a Theme in Struts 2 | Vita Rara PostGIS数据转换工具 Creating a Domain-Specific Modeling Language for an Existing Framework (转www.metacase.com) Article Template Analyzing Card Sort Results with a Spreadsheet Template - Boxes and Arrows: The design behind the design 开源GIS软件PostGIS简介 Creating Vanity URLs Creating an Eclipse View Creating the Spec File Creating the LiveUSB Eclipse Template用法探讨 Eclipse Template用法探讨 Eclipse Template用法探讨 TE Resume Template Qt 4.6: Creating Shared Libraries Creating /removing Services in xp PostGIS开启开源空间数据库地将来