blob: de390c05b6e2bc687354ff7fc08f37517dfccd9c (
plain)
1
2
3
4
5
6
7
8
9
|
CREATE USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}' CREATEDB;
-- in case someone runs this second time accidentally
ALTER USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}' CREATEDB;
CREATE DATABASE {{pleroma_user}};
ALTER DATABASE {{pleroma_user}} OWNER TO {{pleroma_user}};
\c {{pleroma_user}};
--Extensions made by ecto.migrate that need superuser access
CREATE EXTENSION IF NOT EXISTS citext;
CREATE EXTENSION IF NOT EXISTS pg_trgm;
|
