src.nth.io/

summaryrefslogtreecommitdiff
path: root/pleroma/otp/templates/setup_db.psql.j2
diff options
context:
space:
mode:
authorLuke Hoersten <[email protected]>2020-07-01 13:09:31 -0500
committerLuke Hoersten <[email protected]>2020-07-01 13:09:31 -0500
commitf416313d565ffee974c75a58772a52ba454d9a9e (patch)
tree54eaa7f78553bc44610b4b42b13b4e3b9039f311 /pleroma/otp/templates/setup_db.psql.j2
parentf5d7e99ae8771d78904e6f6755613ebac4597b43 (diff)
parentd5a690b1e03a998510d48d2f39d1a224c64d82ff (diff)
merge
Diffstat (limited to 'pleroma/otp/templates/setup_db.psql.j2')
-rw-r--r--pleroma/otp/templates/setup_db.psql.j27
1 files changed, 7 insertions, 0 deletions
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";