aboutsummaryrefslogtreecommitdiffstats
path: root/roles/jails/02_postgres/defaults/main.yml
blob: b01e2c37ad08dbe7fa7049beee08af911727bcca (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
userland: "15.0-RELEASE"
devfs_ruleset: 5

zfs:
  - name: zroot/jails/volumes/postgres_data
    mountpoint: /var/db/postgres
    owner: "770"
    group: "770"
    mode: "0755"

jail_conf_options:
  - "allow.raw_sockets"
  - "allow.sysvipc"

pkg:
  - postgresql18-server
  - postgresql18-pgvector
  - postgresql18-contrib

services:
  - postgresql

pg_users:
  - immich

pg_databases:
  - name: immich
    owner: immich
    init: "CREATE EXTENSION IF NOT EXISTS vector; ALTER EXTENSION vector UPDATE;"