aboutsummaryrefslogtreecommitdiff
path: root/lib/mix/tasks/sample_psql.eex
diff options
context:
space:
mode:
authorHenry Jameson <me@hjkos.com>2017-11-26 20:57:49 +0300
committerHenry Jameson <me@hjkos.com>2017-12-04 03:56:54 +0300
commit0673511d3939c04efd0e3fd350c47b4bfb3e322e (patch)
treeadec2ac87dc761bf744202103f7d3f20391cf92d /lib/mix/tasks/sample_psql.eex
parentd08a34e88b0d42f403755e1bdbaf015784ebbe74 (diff)
downloadpleroma-0673511d3939c04efd0e3fd350c47b4bfb3e322e.tar.gz
first version of safe DB setup
Diffstat (limited to 'lib/mix/tasks/sample_psql.eex')
-rw-r--r--lib/mix/tasks/sample_psql.eex6
1 files changed, 6 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..5353fa216
--- /dev/null
+++ b/lib/mix/tasks/sample_psql.eex
@@ -0,0 +1,6 @@
+CREATE 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 citext;