pleroma/otp/templates/setup_db.psql.j2
changeset 227 2e0366f2dcbe
parent 103 78a072bbf3c1
equal deleted inserted replaced
226:ce33bf94045f 227:2e0366f2dcbe
     1 CREATE USER {{pleroma_db_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}';
     1 CREATE USER {{pleroma_db_user}};
       
     2 ALTER USER {{pleroma_db_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}';
     2 CREATE DATABASE {{pleroma_db}} WITH OWNER {{pleroma_db_user}};
     3 CREATE DATABASE {{pleroma_db}} WITH OWNER {{pleroma_db_user}};
     3 \c {{pleroma_db}};
     4 \c {{pleroma_db}};
     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;