Statistics
| Branch: | Tag: | Revision:

root / snf-deploy / files / tmp / db-init.psql @ 705f2c38

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%;