aboutsummaryrefslogtreecommitdiffstats
path: root/roles/jails/02_postgres/tasks/main.yml
diff options
context:
space:
mode:
authorJan Tuomi <jan@jantuomi.fi>2026-07-14 13:18:58 +0300
committerJan Tuomi <jan@jantuomi.fi>2026-07-14 13:18:58 +0300
commitdf3845f026a1437ce4a9bf2004d222f285cdf0bb (patch)
treeb79f35f6330916433c494f337f88a54ca43e62f1 /roles/jails/02_postgres/tasks/main.yml
parent7872660a4fb6c272619283617856d87f901c850c (diff)
Add missing pgvector extension
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