Commit | Line | Data |
---|---|---|
d541c618 AC |
1 | #!/bin/sh -e |
2 | ||
a92add46 CE |
3 | export PGPORT="$2" |
4 | ||
d541c618 AC |
5 | case $1 in |
6 | adduser) | |
a92add46 | 7 | USERNAME=$3 |
53cb7cc1 | 8 | |
46cdd29c CE |
9 | sudo -u postgres psql -h postgres -p $PGPORT -c "CREATE USER $USERNAME" template1 |
10 | sudo -u postgres psql -h postgres -p $PGPORT -c "ALTER TABLESPACE user_$USERNAME OWNER TO $USERNAME" | |
d541c618 | 11 | ;; |
5ad00add | 12 | |
d541c618 | 13 | createdb) |
a92add46 CE |
14 | USERNAME=$3 |
15 | DBNAME_BASE=$4 | |
16 | ENCODING=$5 | |
a215ab4e AC |
17 | DBNAME="${USERNAME}_${DBNAME_BASE}" |
18 | ||
16eaea74 | 19 | if [ -n "$ENCODING" ]; then |
fe789bea AC |
20 | ENCODING="-E $ENCODING" |
21 | fi | |
22 | ||
46cdd29c | 23 | sudo -u postgres createdb -h postgres -p $PGPORT -O $USERNAME -D user_$USERNAME $ENCODING $DBNAME |
d541c618 | 24 | ;; |
5ad00add AC |
25 | |
26 | dropdb) | |
a92add46 CE |
27 | USERNAME=$3 |
28 | DBNAME_BASE=$4 | |
5ad00add AC |
29 | DBNAME="${USERNAME}_${DBNAME_BASE}" |
30 | ||
46cdd29c | 31 | sudo -u postgres dropdb -h postgres -p $PGPORT $DBNAME |
5ad00add AC |
32 | ;; |
33 | ||
d541c618 | 34 | *) |
5ad00add | 35 | echo "Usage: domtool-postgres [adduser <user> | createdb <user> <db> | dropdb <user> <db>]" |
d541c618 AC |
36 | ;; |
37 | esac |