aboutsummaryrefslogtreecommitdiff
path: root/lib/mix/tasks/sample_psql.eex
diff options
context:
space:
mode:
authorlambda <pleromagit@rogerbraun.net>2017-12-08 12:31:14 +0000
committerlambda <pleromagit@rogerbraun.net>2017-12-08 12:31:14 +0000
commitd7da3ca05d87ce7c0c799031c00dd1a80aba9c18 (patch)
treea9e694be48fc48d00ca8ec9738ec64a21906aaa8 /lib/mix/tasks/sample_psql.eex
parentafd0ea37f3284bdfa6ddce99162601615b7ad845 (diff)
parent964e2dd2f055207ac8fa7f8b3612e50860a0472a (diff)
downloadpleroma-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.eex8
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;