view db_schema/setup-db.sh @ 912:d8c66007fa14

netzbetreiber_id is mandatory for ort. A federal ort has netzbetreiber_id 'D'
author Tom Gottfried <tom@intevation.de>
date Fri, 08 Apr 2016 11:14:09 +0200
parents 51051e85348f
children 2b746f4e97d6
line wrap: on
line source
#!/bin/sh
DIR=`dirname $0`

ROLE_NAME=${1:-lada}
ROLE_PW=${2:-$ROLE_NAME}
DB_NAME=${3:-$ROLE_NAME}

psql --command "CREATE USER $ROLE_NAME PASSWORD '$ROLE_PW';"
createdb -E UTF-8 $DB_NAME

psql -d $DB_NAME  --command \
     "CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public"

psql -d $DB_NAME -f $DIR/stammdaten_schema.sql
psql -d $DB_NAME -f $DIR/lada_schema.sql
psql -d $DB_NAME --command \
     "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME;
      GRANT USAGE
            ON ALL SEQUENCES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;
      GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES
            ON ALL TABLES IN SCHEMA stammdaten, bund, land TO $ROLE_NAME;"

psql -d $DB_NAME -f $DIR/stammdaten_data.sql
psql -d $DB_NAME -f $DIR/lada_data.sql
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)