Creating a postgis-enabled database for geocoding

postgis.sh

#!/bin/bash

DATABASE=''
POSTGISPATH=''
USER=''

sudo -u postgres createdb -O $USER $DATABASE
sudo -u postgres psql -d $DATABASE -f $POSTGISPATH/postgis/postgis.sql
sudo -u postgres psql -d $DATABASE -f $POSTGISPATH/spatial_ref_sys.sql
bash $POSTGISPATH/extras/tiger_geocoder/tiger_2010/create_geocode.sh
sudo -u postgres psql -d $DATABASE -c "GRANT ALL ON spatial_ref_sys to $USER"
sudo -u postgres sh $POSTGISPATH/extras/tiger_geocoder/tiger_2010/upgrade_geocoder.sh