6 DIR
=/afs
/hcoop.net
/common
/databases
/$USERNAME/postgres
8 kinit
-k -t /etc
/keytabs
/root.admin.keytab root
/admin
11 if ! vos examine db.
$USERNAME >/dev
/null
2>/dev
/null
; then
12 vos create
-server afs
-partition a
-name db.
$USERNAME -maxquota 5000
13 fs mkmount
-dir /afs
/.hcoop.net
/common
/.databases
/$USERNAME -vol db.
$USERNAME -rw
14 vos release common.databases
15 fs setacl
-dir /afs
/hcoop.net
/common
/databases
/$USERNAME -acl system
:postgres l
16 fs setacl
-dir /afs
/hcoop.net
/common
/databases
/$USERNAME -acl system
:mysql l
17 fs setacl
-dir /afs
/hcoop.net
/common
/databases
/$USERNAME -acl system
:backup rl
20 if ! [ -d $DIR ]; then
21 sudo
-u postgres psql
-c "CREATE USER $USERNAME" template1
23 chown postgres
:postgres
$DIR
24 fs setacl
-dir $DIR -acl system
:postgres
write
25 fs setacl
-dir $DIR -acl system
:backup rl
27 sudo
-u postgres psql
-c "CREATE TABLESPACE user_$USERNAME OWNER $USERNAME LOCATION '$DIR'" template1
33 DBNAME
="${USERNAME}_${DBNAME_BASE}"
35 sudo
-u postgres createdb
-O $USERNAME -D user_
$USERNAME $DBNAME
38 echo "Usage: domtool-postgres [adduser <user> | createdb <user> <table>]"