From 52eafe0054688b9a582688fd6a986b91700c69db Mon Sep 17 00:00:00 2001 From: Luke Hoersten Date: Thu, 27 Dec 2018 23:53:13 -0500 Subject: Updated for latest pleroma version. --- roles/pleroma/templates/setup_db.psql.j2 | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) (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 de390c0..0b4a87c 100644 --- a/roles/pleroma/templates/setup_db.psql.j2 +++ b/roles/pleroma/templates/setup_db.psql.j2 @@ -1,9 +1,7 @@ -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}}; +CREATE USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}'; +CREATE DATABASE {{pleroma_user}} OWNER {{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; +CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; -- cgit v1.2.3