diff -r dc20ec78acdd -r d8c87a41cc6d roles/pleroma/templates/setup_db.psql.j2 --- a/roles/pleroma/templates/setup_db.psql.j2 Sat Jan 19 13:45:58 2019 -0600 +++ b/roles/pleroma/templates/setup_db.psql.j2 Sun Nov 17 08:14:06 2019 -0600 @@ -1,6 +1,5 @@ CREATE USER {{pleroma_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}'; -CREATE DATABASE {{pleroma_user}}; -ALTER DATABASE {{pleroma_user}} OWNER TO {{pleroma_user}}; +CREATE DATABASE {{pleroma_user}} WITH OWNER {{pleroma_user}}; \c {{pleroma_user}}; --Extensions made by ecto.migrate that need superuser access CREATE EXTENSION IF NOT EXISTS citext;