X-Git-Url: https://git.hcoop.net/hcoop/scripts.git/blobdiff_plain/3a9bd77a91c7228ac90171603a9260337a9e9bfb..82cda9f8fe4595f243af80a3acef7ea7e8d939a4:/create-user-database

diff --git a/create-user-database b/create-user-database
new file mode 100644
index 0000000..4725bd8
--- /dev/null
+++ b/create-user-database
@@ -0,0 +1,22 @@
+#!/bin/bash -ex
+
+# DO NOT EXECUTE DIRECTLY
+# This is only to be executed by create-user
+
+PATHBITS=$1
+DBPATH=/srv/databases/$PATHBITS
+PGDIR=$DBPATH/postgres
+MYSQLDIR=$DBPATH/mysql
+
+# Create postgres user and tablespace placeholder within volume
+if ! test -d $PGDIR; then
+  mkdir -p $PGDIR
+  chown postgres:postgres $PGDIR
+fi
+
+sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1
+fi
+
+# Create mysql user and databases placeholder within volume
+mkdir -p $MYSQLDIR
+chown mysql:mysql $MYSQLDIR
\ No newline at end of file