Merge branch 'improve-server-config-examples' into 'develop'
[akkoma] / lib / mix / tasks / sample_psql.eex
1 CREATE USER pleroma WITH ENCRYPTED PASSWORD '<%= dbpass %>' CREATEDB;
2 -- in case someone runs this second time accidentally
3 ALTER USER pleroma WITH ENCRYPTED PASSWORD '<%= dbpass %>' CREATEDB;
4 CREATE DATABASE pleroma_dev;
5 ALTER DATABASE pleroma_dev OWNER TO pleroma;
6 \c pleroma_dev;
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;