Commit | Line | Data |
---|---|---|
82cda9f8 CE |
1 | #!/bin/bash -ex |
2 | ||
3 | # DO NOT EXECUTE DIRECTLY | |
4 | # This is only to be executed by create-user | |
5 | ||
58df4059 CE |
6 | USER=$1 |
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 | |
82cda9f8 CE |
9 | DBPATH=/srv/databases/$PATHBITS |
10 | PGDIR=$DBPATH/postgres | |
11 | MYSQLDIR=$DBPATH/mysql | |
12 | ||
13 | # Create postgres user and tablespace placeholder within volume | |
14 | if ! test -d $PGDIR; then | |
15 | mkdir -p $PGDIR | |
16 | chown postgres:postgres $PGDIR | |
17 | fi | |
18 | ||
19 | sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1 | |
82cda9f8 CE |
20 | |
21 | # Create mysql user and databases placeholder within volume | |
22 | mkdir -p $MYSQLDIR | |
23 | chown mysql:mysql $MYSQLDIR |