git.squeep.com Git - akkoma/blob - lib/mix/tasks/pleroma/sample_psql.eex

   1 CREATE USER <%= dbuser %> WITH ENCRYPTED PASSWORD '<%= dbpass %>' CREATEDB;
   2 -- in case someone runs this second time accidentally
   3 ALTER USER <%= dbuser %> WITH ENCRYPTED PASSWORD '<%= dbpass %>' CREATEDB;
   4 CREATE DATABASE <%= dbname %>;
   5 ALTER DATABASE <%= dbname %> OWNER TO <%= dbuser %>;
   6 \c <%= dbname %>;
   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;