create-user-database

   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