fabric-spatial-db-template.py

def create_spatial_database_template():
    sudo("""createdb -E UTF8 template_postgis -U postgres""")
    try:
        sudo("""createlang -d template_postgis plpgsql -U postgres""")
    except:
        pass
    sudo("""psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql -U postgres""")
    sudo("""psql -d template_postgis -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql -U postgres""")
    sudo("""psql -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;" -U postgres""")
    sudo("""psql -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;" -U postgres""")