From: clinton_admin <clinton_admin@fritz.hcoop.net>
Date: Sun, 25 Mar 2012 07:13:23 +0000 (-0400)
Subject: Escape tablespace name when creating postgresql tablespace
X-Git-Url: https://git.hcoop.net/hcoop/scripts.git/commitdiff_plain/42255e0b020923e3564c289ec17f6a1017f2052d?ds=sidebyside

Escape tablespace name when creating postgresql tablespace
* Previously, a name with a '-' would break things
* Usernames containing '"' are invalid anyway so we should be bulletproof
---

diff --git a/create-user-database b/create-user-database
index cf855c4..bc2ca60 100755
--- a/create-user-database
+++ b/create-user-database
@@ -16,7 +16,7 @@ MYSQLDIR=$DBPATH/mysql
 if ! test -d $PGDIR; then
   mkdir -p $PGDIR
   chown postgres:postgres $PGDIR
-  sudo -u postgres psql -c "CREATE TABLESPACE user_$USER OWNER postgres LOCATION '$PGDIR'" template1
+  sudo -u postgres psql -c "CREATE TABLESPACE \"user_$USER\" OWNER postgres LOCATION '$PGDIR'" template1
 fi
 
 # Create mysql user and databases placeholder within volume