changeset 1085:1d1c50b7a23b

Run psql quietly when running large SQL scripts.
author Tom Gottfried <tom@intevation.de>
date Thu, 13 Oct 2016 17:01:31 +0200 (2016-10-13)
parents 99c6c644773b
children 259a6b638968
files db_schema/setup-db.sh
diffstat 1 files changed, 5 insertions(+), 5 deletions(-) [+]
line wrap: on
line diff
--- a/db_schema/setup-db.sh	Tue Oct 11 16:38:04 2016 +0200
+++ b/db_schema/setup-db.sh	Thu Oct 13 17:01:31 2016 +0200
@@ -59,10 +59,10 @@
      "CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public"
 
 echo create stammdaten schema
-psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_schema.sql
+psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_schema.sql
 
 echo create lada schema
-psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_schema.sql
+psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_schema.sql
 echo set grants
 psql $DB_CONNECT_STRING -d $DB_NAME --command \
      "GRANT USAGE ON SCHEMA stammdaten, bund, land TO $ROLE_NAME;
@@ -73,10 +73,10 @@
 
 if [ "$NO_DATA" != "true" ]; then
     echo import stammdaten
-    psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data.sql
+    psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/stammdaten_data.sql
 
     echo import lada test data
-    psql $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_data.sql
+    psql -q $DB_CONNECT_STRING -d $DB_NAME -f $DIR/lada_data.sql
 
     echo create user $ROLE_NAME
     psql $DB_CONNECT_STRING -d $DB_NAME --command "CREATE SCHEMA geo AUTHORIZATION $ROLE_NAME"
@@ -89,7 +89,7 @@
     fi
     unzip vg250_${TS}.utm32s.shape.ebenen.zip "*VG250_GEM*"
     cd vg250_${TS}.utm32s.shape.ebenen/vg250_ebenen/
-    shp2pgsql VG250_GEM geo.gem_utm | psql $DB_CONNECT_STRING -d $DB_NAME
+    shp2pgsql VG250_GEM geo.gem_utm | psql -q $DB_CONNECT_STRING -d $DB_NAME
     cd /tmp
     rm -rf vg250_${TS}.utm32s.shape.ebenen
 fi
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)