UPDATE pg_database SET datctype='C', datcollate='C' WHERE datname='template1'; CREATE USER %SYNNEFO_USER% WITH PASSWORD '%SYNNEFO_DB_PASSWD%' CREATEDB; CREATE DATABASE snf_apps WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0 OWNER=%SYNNEFO_USER%; GRANT ALL PRIVILEGES ON DATABASE snf_apps TO %SYNNEFO_USER%; CREATE DATABASE snf_pithos WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0; OWNER=%SYNNEFO_USER%; GRANT ALL PRIVILEGES ON DATABASE snf_pithos TO %SYNNEFO_USER%;