roles/pleroma/templates/setup_db.psql.j2
changeset 75 d8c87a41cc6d
parent 66 652a236229c2
equal deleted inserted replaced
74:dc20ec78acdd 75:d8c87a41cc6d
     1 CREATE USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}';
     1 CREATE USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}';
     2 CREATE DATABASE {{pleroma_user}};
     2 CREATE DATABASE {{pleroma_user}} WITH OWNER {{pleroma_user}};
     3 ALTER DATABASE {{pleroma_user}} OWNER TO {{pleroma_user}};
       
     4 \c {{pleroma_user}};
     3 \c {{pleroma_user}};
     5 --Extensions made by ecto.migrate that need superuser access
     4 --Extensions made by ecto.migrate that need superuser access
     6 CREATE EXTENSION IF NOT EXISTS citext;
     5 CREATE EXTENSION IF NOT EXISTS citext;
     7 CREATE EXTENSION IF NOT EXISTS pg_trgm;
     6 CREATE EXTENSION IF NOT EXISTS pg_trgm;
     8 CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
     7 CREATE EXTENSION IF NOT EXISTS "uuid-ossp";