aboutsummaryrefslogtreecommitdiffstats
path: root/roles/jails/02_postgres/tasks/main.yml
diff options
context:
space:
mode:
Diffstat (limited to 'roles/jails/02_postgres/tasks/main.yml')
-rw-r--r--roles/jails/02_postgres/tasks/main.yml7
1 files changed, 7 insertions, 0 deletions
diff --git a/roles/jails/02_postgres/tasks/main.yml b/roles/jails/02_postgres/tasks/main.yml
index 8ce0864..618c040 100644
--- a/roles/jails/02_postgres/tasks/main.yml
+++ b/roles/jails/02_postgres/tasks/main.yml
@@ -49,3 +49,10 @@
loop: "{{ pg_databases }}"
register: _pg_db
changed_when: "'CREATE DATABASE' in _pg_db.stdout"
+
+- name: Run database init SQL
+ shell: "su -l postgres -c \"psql -d {{ item.item.name }} -c \\\"{{ item.item.init }}\\\"\""
+ loop: "{{ _pg_db.results }}"
+ loop_control:
+ label: "{{ item.item.name }}"
+ when: item.changed and item.item.init is defined