diff options
| -rw-r--r-- | roles/jails/02_postgres/defaults/main.yml | 7 | ||||
| -rw-r--r-- | roles/jails/02_postgres/tasks/main.yml | 7 |
2 files changed, 11 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;" 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 |