added sql to move to utf8

[fai-configs.git] / files / etc / init.d / install-mediagoblin / DEFAULT

diff --git a/files/etc/init.d/install-mediagoblin/DEFAULT b/files/etc/init.d/install-mediagoblin/DEFAULT
old mode 100644 (file)
new mode 100755 (executable)
index 0b3986f..dcf7e8e
--- a/files/etc/init.d/install-mediagoblin/DEFAULT
+++ b/files/etc/init.d/install-mediagoblin/DEFAULT
@@ -4,6 +4,12 @@ cd GMG_PATH_TOKEN
 if [ ! -d mediagoblin ]; then
 
     # Create the GMG user
+    sudo -u poostgres psql -c "UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1'"
+    sudo -u poostgres psql -c "DROP DATABASE template1"
+    sudo -u poostgres psql -c "CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING='UNICODE' LC_COLLATE='en_US.UTF8' LC_CTYPE='en_US.UTF8'"
+    sudo -u poostgres psql -c "UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1'"
+    sudo -u poostgres psql -c "UPDATE pg_database SET datallowconn = FALSE WHERE datname = 'template1'"
+
     sudo -u postgres createuser -A -D mediagoblin
     # Crea te GMG database
     sudo -u postgres createdb -E UNICODE -O mediagoblin mediagoblin