Generate empty PostGres DB for OSM

planetosm.sh

SET pgpass=secret
SET pguser=postgres

DROPDB -U postgres -h localhost planetosm
CREATEDB -U postgres -h localhost -T template_postgis -e -O postgres planetosm
psql -h localhost -t -d planetosm -U postgres -a  -c  "CREATE SCHEMA markware;"
psql -h localhost -t -d planetosm -U postgres -a  -c  "ALTER DATABASE planetosm SET search_path='markware','public';"
psql -h localhost -t -d planetosm -U postgres -a  -c  "GRANT ALL PRIVILEGES ON DATABASE planetosm to osm;"
psql -h localhost -t -d planetosm -U postgres -a  -c  "CREATE EXTENSION hstore;"
psql -h localhost -U postgres -f /home/osm900913.sql planetosm 
VACUUMDB -h localhost -U postgres -d planetosm -z -e