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 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

(limited to 'roles/jails/02_postgres/defaults/main.yml')

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