From d5a690b1e03a998510d48d2f39d1a224c64d82ff Mon Sep 17 00:00:00 2001 From: Luke Hoersten Date: Wed, 1 Jul 2020 12:16:48 -0500 Subject: Split out aws s3 and otp roles. --- pleroma/otp/templates/setup_db.psql.j2 | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 pleroma/otp/templates/setup_db.psql.j2 (limited to 'pleroma/otp/templates/setup_db.psql.j2') diff --git a/pleroma/otp/templates/setup_db.psql.j2 b/pleroma/otp/templates/setup_db.psql.j2 new file mode 100644 index 0000000..1b27174 --- /dev/null +++ b/pleroma/otp/templates/setup_db.psql.j2 @@ -0,0 +1,7 @@ +CREATE USER {{pleroma_db_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}'; +CREATE DATABASE {{pleroma_db}} WITH OWNER {{pleroma_db_user}}; +\c {{pleroma_db}}; +--Extensions made by ecto.migrate that need superuser access +CREATE EXTENSION IF NOT EXISTS citext; +CREATE EXTENSION IF NOT EXISTS pg_trgm; +CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; -- cgit v1.2.3