Mercurial > gemma
diff schema/install-db.sh @ 436:8feb64128c34
Fixed install db script to cope with user roles containing whitespace.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Mon, 20 Aug 2018 17:58:56 +0200 |
parents | 88aa790d1437 |
children | 5611cf72cc92 |
line wrap: on
line diff
--- a/schema/install-db.sh Mon Aug 20 16:58:55 2018 +0200 +++ b/schema/install-db.sh Mon Aug 20 17:58:56 2018 +0200 @@ -128,12 +128,9 @@ read a if [[ $a == "yes" ]] ; then dropdb -p "$port" "$db" - for r in `psql -p $port -t -c '\du' | awk -F '|' \ - '$1 "." $3 ~ /waterway_user|waterway_admin|sys_admin|pw_reset/ \ - {print $1}'` - do - dropuser -p "$port" "$r" - done + psql -p $port -A -t -c '\du' | awk -F '|' -v port=$port \ + '$1 "." $3 ~ /waterway_user|waterway_admin|sys_admin|pw_reset/ \ + { system("dropuser -p " port " \"" $1 "\"") }' else echo "No harm done." fi