From 608c3aa2dd6a35d8fe434d60822314cc23bd4314 Mon Sep 17 00:00:00 2001 From: Luke Hoersten Date: Thu, 16 Aug 2018 20:25:56 -0500 Subject: Initial commit. --- roles/pleroma/templates/setup_db.psql.j2 | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 roles/pleroma/templates/setup_db.psql.j2 (limited to 'roles/pleroma/templates/setup_db.psql.j2') diff --git a/roles/pleroma/templates/setup_db.psql.j2 b/roles/pleroma/templates/setup_db.psql.j2 new file mode 100644 index 0000000..de390c0 --- /dev/null +++ b/roles/pleroma/templates/setup_db.psql.j2 @@ -0,0 +1,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; -- cgit v1.2.3