From df3845f026a1437ce4a9bf2004d222f285cdf0bb Mon Sep 17 00:00:00 2001
From: Jan Tuomi <jan@jantuomi.fi>
Date: Tue, 14 Jul 2026 13:18:58 +0300
Subject: Add missing pgvector extension

---
 roles/jails/02_postgres/tasks/main.yml | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'roles/jails/02_postgres/tasks')

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
-- 
cgit v1.3