diff -r 63586cf10d46 -r 56531bbfd074 roles/pleroma/templates/setup_db.psql.j2 --- a/roles/pleroma/templates/setup_db.psql.j2 Wed Sep 05 16:42:56 2018 -0500 +++ b/roles/pleroma/templates/setup_db.psql.j2 Thu Dec 27 23:53:13 2018 -0500 @@ -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";