Some might find this useful for creating PostGIS databases without having to be postgresql superusers. The idea is to create a template_postgis database, install plpgsql and postgis into it, and then use this database as a template when creating new PostGIS databases.
Now non-superuser’s can create postgis db’s using template_postgis:
createdb -h host-name my_gisdb -W -T template_postgis
Pingback: chetantiwari.com » Blog Archive » Allow non superuser accounts to create spatial databases
Pingback: PostGIS is here! « The University of Manchester Geospatial Blog
This is a good tutorial on how to create a spatial database template, but I don't understand the need for a vacuum freeze or even a vacuum full. Could comment on why this would be important.
Thanks
Jean, we have just loaded a large amount of data into the template_postgis database. To make sure that the query planner has up-to-date stats its generally good practice to run Vacuum after making a large change to a database. Secondly we are also locking the database to prevent any further changes. So its a good idea to do it at this stage.
Pingback: OSM + ImpOSM + TileMill « geomaticblog