1 CREATE USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}' CREATEDB;

     2 -- in case someone runs this second time accidentally

     3 ALTER USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}' CREATEDB;

     4 CREATE DATABASE {{pleroma_user}};

     5 ALTER DATABASE {{pleroma_user}} OWNER TO {{pleroma_user}};

     6 \c {{pleroma_user}};

     7 --Extensions made by ecto.migrate that need superuser access

     8 CREATE EXTENSION IF NOT EXISTS citext;

     9 CREATE EXTENSION IF NOT EXISTS pg_trgm;