diff options
Diffstat (limited to 'roles/pleroma/templates/setup_db.psql.j2')
| -rw-r--r-- | roles/pleroma/templates/setup_db.psql.j2 | 9 |
1 files changed, 9 insertions, 0 deletions
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; |