diff options
author | lambda <pleromagit@rogerbraun.net> | 2017-12-08 12:31:14 +0000 |
---|---|---|
committer | lambda <pleromagit@rogerbraun.net> | 2017-12-08 12:31:14 +0000 |
commit | d7da3ca05d87ce7c0c799031c00dd1a80aba9c18 (patch) | |
tree | a9e694be48fc48d00ca8ec9738ec64a21906aaa8 /lib/mix/tasks/sample_psql.eex | |
parent | afd0ea37f3284bdfa6ddce99162601615b7ad845 (diff) | |
parent | 964e2dd2f055207ac8fa7f8b3612e50860a0472a (diff) | |
download | pleroma-d7da3ca05d87ce7c0c799031c00dd1a80aba9c18.tar.gz |
Merge branch 'postgresetup' into 'develop'
first version of safe DB setup
See merge request pleroma/pleroma!32
Diffstat (limited to 'lib/mix/tasks/sample_psql.eex')
-rw-r--r-- | lib/mix/tasks/sample_psql.eex | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/lib/mix/tasks/sample_psql.eex b/lib/mix/tasks/sample_psql.eex new file mode 100644 index 000000000..18e322efc --- /dev/null +++ b/lib/mix/tasks/sample_psql.eex @@ -0,0 +1,8 @@ +CREATE USER pleroma WITH ENCRYPTED PASSWORD '<%= dbpass %>' CREATEDB; +-- in case someone runs this second time accidentally +ALTER USER pleroma WITH ENCRYPTED PASSWORD '<%= dbpass %>' CREATEDB; +CREATE DATABASE pleroma_dev; +ALTER DATABASE pleroma_dev OWNER TO pleroma; +\c pleroma_dev; +--Extensions made by ecto.migrate that need superuser access +CREATE EXTENSION IF NOT EXISTS citext; |