From 035f6e2253e1a3f3283ca3e0f7044da8880880e4 Mon Sep 17 00:00:00 2001 From: Luke Hoersten Date: Mon, 31 Dec 2018 15:50:19 -0600 Subject: Updated for external DB. --- roles/pleroma/templates/setup_db.psql.j2 | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (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 index 0b4a87c..459bec8 100644 --- a/roles/pleroma/templates/setup_db.psql.j2 +++ b/roles/pleroma/templates/setup_db.psql.j2 @@ -1,5 +1,6 @@ CREATE USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}'; -CREATE DATABASE {{pleroma_user}} OWNER {{pleroma_user}}; +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; -- cgit v1.2.3