Statistics
| Branch: | Tag: | Revision:

root / snf-deploy / files / tmp / db-init.psql @ 952a28c0

History | View | Annotate | Download (512 Bytes)

1
UPDATE pg_database SET datctype='C', datcollate='C' WHERE datname='template1';
2

    
3
CREATE USER %SYNNEFO_USER% WITH PASSWORD '%SYNNEFO_DB_PASSWD%' CREATEDB;
4

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

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