X-Git-Url: https://git.hcoop.net/hcoop/domtool2.git/blobdiff_plain/fd59cbe6ef388ea0b4b6380e5887a4d5e6d6b93e..53043cda16a4efd64705d7fc5ca188f67c92c84f:/src/plugins/domtool-postgres diff --git a/src/plugins/domtool-postgres b/src/plugins/domtool-postgres index d05999f..45d7735 100755 --- a/src/plugins/domtool-postgres +++ b/src/plugins/domtool-postgres @@ -1,32 +1,34 @@ #!/bin/sh -e +export PGPORT="$2" + case $1 in adduser) - USERNAME=$2 + USERNAME=$3 - sudo -u postgres psql -h postgres -c "CREATE USER $USERNAME" template1 - sudo -u postgres psql -h postgres -c "ALTER TABLESPACE user_$USERNAME OWNER TO $USERNAME" + sudo -u postgres psql -h postgres -p $PGPORT -c "CREATE USER $USERNAME" template1 + sudo -u postgres psql -h postgres -p $PGPORT -c "ALTER TABLESPACE user_$USERNAME OWNER TO $USERNAME" ;; createdb) - USERNAME=$2 - DBNAME_BASE=$3 - ENCODING=$4 + USERNAME=$3 + DBNAME_BASE=$4 + ENCODING=$5 DBNAME="${USERNAME}_${DBNAME_BASE}" if [ -n "$ENCODING" ]; then ENCODING="-E $ENCODING" fi - sudo -u postgres createdb -h postgres -O $USERNAME -D user_$USERNAME $ENCODING $DBNAME + sudo -u postgres createdb -h postgres -p $PGPORT -O $USERNAME -D user_$USERNAME $ENCODING $DBNAME ;; dropdb) - USERNAME=$2 - DBNAME_BASE=$3 + USERNAME=$3 + DBNAME_BASE=$4 DBNAME="${USERNAME}_${DBNAME_BASE}" - sudo -u postgres dropdb -h postgres $DBNAME + sudo -u postgres dropdb -h postgres -p $PGPORT $DBNAME ;; *)