| | 1 | #!/bin/bash -ex |
| | 2 | |
| | 3 | # DO NOT EXECUTE DIRECTLY |
| | 4 | # This is only to be executed by create-user |
| | 5 | |
| | 6 | PATHBITS=$1 |
| | 7 | DBPATH=/srv/databases/$PATHBITS |
| | 8 | PGDIR=$DBPATH/postgres |
| | 9 | MYSQLDIR=$DBPATH/mysql |
| | 10 | |
| | 11 | # Create postgres user and tablespace placeholder within volume |
| | 12 | if ! test -d $PGDIR; then |
| | 13 | mkdir -p $PGDIR |
| | 14 | chown postgres:postgres $PGDIR |
| | 15 | fi |
| | 16 | |
| | 17 | sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1 |
| | 18 | fi |
| | 19 | |
| | 20 | # Create mysql user and databases placeholder within volume |
| | 21 | mkdir -p $MYSQLDIR |
| | 22 | chown mysql:mysql $MYSQLDIR |
HCoop / clinton / scripts.git / blame_incremental