diff options
| author | Luke Hoersten <[email protected]> | 2020-01-19 13:41:08 -0600 |
|---|---|---|
| committer | Luke Hoersten <[email protected]> | 2020-01-19 13:41:08 -0600 |
| commit | 36c11d8d18deec8dbc5a0e2483d9bfb6c73faae0 (patch) | |
| tree | 2e762e613ae636ad37b1c86ce9b3a1d23800c187 /roles/pleroma-otp/templates/setup_db.psql.j2 | |
| parent | 9f784f33470fc8b70936c2980f53182ff21481a1 (diff) | |
Added WIP pleroma OTP role.
Diffstat (limited to 'roles/pleroma-otp/templates/setup_db.psql.j2')
| -rw-r--r-- | roles/pleroma-otp/templates/setup_db.psql.j2 | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/roles/pleroma-otp/templates/setup_db.psql.j2 b/roles/pleroma-otp/templates/setup_db.psql.j2 new file mode 100644 index 0000000..1b27174 --- /dev/null +++ b/roles/pleroma-otp/templates/setup_db.psql.j2 @@ -0,0 +1,7 @@ +CREATE USER {{pleroma_db_user}} WITH ENCRYPTED PASSWORD '{{pleroma_db_passwd}}'; +CREATE DATABASE {{pleroma_db}} WITH OWNER {{pleroma_db_user}}; +\c {{pleroma_db}}; +--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"; |