roles/pleroma/templates/setup_db.psql.j2
changeset 66 652a236229c2
parent 63 56531bbfd074
child 75 d8c87a41cc6d
equal deleted inserted replaced
65:4538ad030906 66:652a236229c2
     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}} OWNER {{pleroma_user}};
     2 CREATE DATABASE {{pleroma_user}};
       
     3 ALTER DATABASE {{pleroma_user}} OWNER TO {{pleroma_user}};
     3 \c {{pleroma_user}};
     4 \c {{pleroma_user}};
     4 --Extensions made by ecto.migrate that need superuser access
     5 --Extensions made by ecto.migrate that need superuser access
     5 CREATE EXTENSION IF NOT EXISTS citext;
     6 CREATE EXTENSION IF NOT EXISTS citext;
     6 CREATE EXTENSION IF NOT EXISTS pg_trgm;
     7 CREATE EXTENSION IF NOT EXISTS pg_trgm;
     7 CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
     8 CREATE EXTENSION IF NOT EXISTS "uuid-ossp";