3 # DO NOT EXECUTE DIRECTLY
4 # This is only to be executed by create-user
7 # (If it's not clear, for user fred, PATHBITS = f/fr/fred)
8 PATHBITS
=`echo $USER | head -c 1`/`echo $USER | head -c 2`/$USER
9 DBPATH
=/srv
/databases
/$PATHBITS
10 PGDIR
=$DBPATH/postgres
11 PGNEWDIR
="$DBPATH/postgres-9.1"
12 MYSQLDIR
=$DBPATH/mysql
14 # Create postgres user and tablespace placeholder within volume
15 # FIXME: This assumes the status-quo of database accounts not being
16 # removed by destroy-user...
17 if ! test -d $PGDIR; then
20 chown postgres
:postgres
$PGDIR
21 sudo
-u postgres psql
--cluster 8.1/main
-c "CREATE TABLESPACE \"user_$USER\" OWNER postgres LOCATION '$PGDIR'" template1
24 if ! test -d $PGNEWDIR; then
27 chown postgres
:postgres
$PGNEWDIR
28 sudo
-u postgres psql
--cluster 9.1/main
-c "CREATE TABLESPACE \"user_$USER\" OWNER postgres LOCATION '$PGNEWDIR'" template1
31 # Create mysql user and databases placeholder within volume
32 # FIXME: Same as postgres...
33 if ! test -d $MYSQLDIR; then
35 chown mysql
:mysql
$MYSQLDIR