diff options
| author | Henry Jameson <me@hjkos.com> | 2017-12-04 02:06:05 +0300 |
|---|---|---|
| committer | Henry Jameson <me@hjkos.com> | 2017-12-04 03:56:54 +0300 |
| commit | 6b60f5f64ab9d7598ccdb2545b0e5560991ff5f3 (patch) | |
| tree | 80309dd1a12b32ed989bb0cb5e4133b2eb399830 /lib/mix/tasks/sample_psql.eex | |
| parent | 071f518028e20d1f22811d6a10f120bebe26c2ce (diff) | |
| download | pleroma-6b60f5f64ab9d7598ccdb2545b0e5560991ff5f3.tar.gz | |
made psql script compatible with migrations or generate_config reruns
Diffstat (limited to 'lib/mix/tasks/sample_psql.eex')
| -rw-r--r-- | lib/mix/tasks/sample_psql.eex | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/lib/mix/tasks/sample_psql.eex b/lib/mix/tasks/sample_psql.eex index 5353fa216..9eb7f65b0 100644 --- a/lib/mix/tasks/sample_psql.eex +++ b/lib/mix/tasks/sample_psql.eex @@ -1,6 +1,8 @@ -CREATE USER pleroma WITH ENCRYPTED PASSWORD '<%= dbpass %>' CREATEDB; -CREATE DATABASE pleroma_dev; +CREATE USER IF NOT EXISTS pleroma WITH ENCRYPTED PASSWORD '<%= dbpass %>' CREATEDB; +-- in case someone runs this second time accidentally +ALTER USER pleroma WITH ENCRYPTED PASSWORD '<%= dbpass %>' CREATEDB; +CREATE DATABASE IF NOT EXISTS pleroma_dev; ALTER DATABASE pleroma_dev OWNER TO pleroma; \c pleroma_dev; --Extensions made by ecto.migrate that need superuser access -CREATE EXTENSION citext; +CREATE EXTENSION IF NOT EXISTS citext; |