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