createdb -U postgres -h localhost postgis_template
createlang -U postgres -d postgis_template plpgsql 
psql -U postgres -d postgis_template -f /usr/share/postgresql-8.3-postgis/lwpostgis.sql
psql -U postgres -d postgis_template -f /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql