HCoop
/
clinton
/
scripts.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Update database backup script to connect to fritz
[clinton/scripts.git]
/
create-user-database
diff --git
a/create-user-database
b/create-user-database
old mode 100644
(file)
new mode 100755
(executable)
index
4725bd8
..
99293b0
--- a/
create-user-database
+++ b/
create-user-database
@@
-3,7
+3,9
@@
# DO NOT EXECUTE DIRECTLY
# This is only to be executed by create-user
# DO NOT EXECUTE DIRECTLY
# This is only to be executed by create-user
-PATHBITS=$1
+USER=$1
+# (If it's not clear, for user fred, PATHBITS = f/fr/fred)
+PATHBITS=`echo $USER | head -c 1`/`echo $USER | head -c 2`/$USER
DBPATH=/srv/databases/$PATHBITS
PGDIR=$DBPATH/postgres
MYSQLDIR=$DBPATH/mysql
DBPATH=/srv/databases/$PATHBITS
PGDIR=$DBPATH/postgres
MYSQLDIR=$DBPATH/mysql
@@
-15,7
+17,6
@@
if ! test -d $PGDIR; then
fi
sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1
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
# Create mysql user and databases placeholder within volume
mkdir -p $MYSQLDIR