X-Git-Url: https://git.hcoop.net/hcoop/domtool2.git/blobdiff_plain/53cb7cc1a416d38a26a5287478e00920f3d67b7c..fe789bea628b15229156c8a4272c2b6063c9b1a0:/src/plugins/domtool-postgres diff --git a/src/plugins/domtool-postgres b/src/plugins/domtool-postgres index 1d945d4..214e9ac 100755 --- a/src/plugins/domtool-postgres +++ b/src/plugins/domtool-postgres @@ -7,14 +7,29 @@ case $1 in sudo -u postgres psql -c "CREATE USER $USERNAME" template1 sudo -u postgres psql -c "ALTER TABLESPACE user_$USERNAME OWNER TO $USERNAME" ;; + createdb) USERNAME=$2 DBNAME_BASE=$3 + ENCODING=$4 DBNAME="${USERNAME}_${DBNAME_BASE}" - sudo -u postgres createdb -O $USERNAME -D user_$USERNAME $DBNAME + if [ -n $ENCODING ]; then + ENCODING="-E $ENCODING" + fi + + sudo -u postgres createdb -O $USERNAME -D user_$USERNAME $ENCODING $DBNAME ;; + + dropdb) + USERNAME=$2 + DBNAME_BASE=$3 + DBNAME="${USERNAME}_${DBNAME_BASE}" + + sudo -u postgres dropdb $DBNAME + ;; + *) - echo "Usage: domtool-postgres [adduser | createdb ]" + echo "Usage: domtool-postgres [adduser | createdb | dropdb ]" ;; esac