aboutsummaryrefslogtreecommitdiffstats
path: root/roles/jails/02_postgres/defaults/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/defaults/main.yml
parent7872660a4fb6c272619283617856d87f901c850c (diff)
Add missing pgvector extension
Diffstat (limited to 'roles/jails/02_postgres/defaults/main.yml')
-rw-r--r--roles/jails/02_postgres/defaults/main.yml7
1 files changed, 4 insertions, 3 deletions
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;"