Mercurial > gemma

comparison schema/install-db.sh @ 273:61f1374f0c44

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Removed hard coded (and in my case wrong) port from dropping users in install-db.sh script.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 30 Jul 2018 12:53:16 +0200
parents c2cef3ce8853
children dfb989088158
comparison
equal deleted inserted replaced
272:5ee0edc01a18 273:61f1374f0c44
95 # Evil mode: drop everything gemma 95 # Evil mode: drop everything gemma
96 echo "Really drop database '$db' and alle gemma roles? [type 'yes']: " 96 echo "Really drop database '$db' and alle gemma roles? [type 'yes']: "
97 read a 97 read a
98 if [[ $a == "yes" ]] ; then 98 if [[ $a == "yes" ]] ; then
99 dropdb -p "$port" "$db" 99 dropdb -p "$port" "$db"
100 for r in `psql -p 5433 -t -c '\du' | awk -F '|' \ 100 for r in `psql -p $port -t -c '\du' | awk -F '|' \
101 '$3 ~/waterway_user|waterway_admin|sys_admin/ \ 101 '$3 ~/waterway_user|waterway_admin|sys_admin/ \
102 || $1 ~/waterway_user|waterway_admin|sys_admin/ \ 102 || $1 ~/waterway_user|waterway_admin|sys_admin/ \
103 {print $1}'` 103 {print $1}'`
104 do 104 do
105 dropuser -p "$port" "$r" 105 dropuser -p "$port" "$r"