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 MYSQLDIR
=$DBPATH/mysql
13 # Create postgres user and tablespace placeholder within volume
14 if ! test -d $PGDIR; then
16 chown postgres
:postgres
$PGDIR
19 sudo
-u postgres psql
-c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1
21 # Create mysql user and databases placeholder within volume
23 chown mysql
:mysql
$MYSQLDIR