Create a template_postgis database Some might find this useful for creating PostGIS databases without having to be PostgreSQL super users. 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-super users can create PostGIS databases using template_postgis:

$ createdb my_geo_db -W -T template_postgis