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/defaults/main.yml | 7 ++++---
 roles/jails/02_postgres/tasks/main.yml    | 7 +++++++
 2 files changed, 11 insertions(+), 3 deletions(-)

(limited to 'roles')

diff --git a/roles/jails/02_postgres/defaults/main.yml b/roles/jails/02_postgres/defaults/main.yml
index fa18195..fb70805 100644
--- a/roles/jails/02_postgres/defaults/main.yml
+++ b/roles/jails/02_postgres/defaults/main.yml
@@ -14,14 +14,15 @@ jail_conf_options:
 
 pkg:
   - postgresql18-server
+  - postgresql18-pgvector
 
 services:
   - postgresql
 
 pg_users:
-  - spliit
   - immich
 
 pg_databases:
-  - { name: spliit, owner: spliit }
-  - { name: immich, owner: immich }
+  - name: immich
+    owner: immich
+    init: "CREATE EXTENSION IF NOT EXISTS vector; ALTER EXTENSION vector UPDATE;"
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