7 sudo
-u postgres psql
-c "CREATE USER $USERNAME" template1
8 sudo
-u postgres psql
-c "ALTER TABLESPACE user_$USERNAME OWNER TO $USERNAME"
14 DBNAME
="${USERNAME}_${DBNAME_BASE}"
16 sudo
-u postgres createdb
-O $USERNAME -D user_
$USERNAME $DBNAME
22 DBNAME
="${USERNAME}_${DBNAME_BASE}"
24 sudo
-u postgres dropdb
$DBNAME
28 echo "Usage: domtool-postgres [adduser <user> | createdb <user> <db> | dropdb <user> <db>]"