Revision 30761818

b/snf-deploy/files/tmp/db-init.psql
1
CREATE DATABASE snf_apps WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0;
2
CREATE USER %SYNNEFO_USER% WITH PASSWORD '%SYNNEFO_DB_PASSWD%';
1
CREATE USER %SYNNEFO_USER% WITH PASSWORD '%SYNNEFO_DB_PASSWD%' CREATEDB;
2

  
3
CREATE DATABASE snf_apps WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0 OWNER=%SYNNEFO_USER%;
3 4
GRANT ALL PRIVILEGES ON DATABASE snf_apps TO %SYNNEFO_USER%;
4 5

  
5
CREATE DATABASE snf_pithos WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0;
6
CREATE DATABASE snf_pithos WITH ENCODING 'UTF8' LC_COLLATE='C' LC_CTYPE='C' TEMPLATE=template0; OWNER=%SYNNEFO_USER%;
6 7
GRANT ALL PRIVILEGES ON DATABASE snf_pithos TO %SYNNEFO_USER%;

Also available in: Unified diff