aboutsummaryrefslogtreecommitdiffstats
path: root/roles/jails/02_postgres/defaults/main.yml
blob: 47c0e5d789765da0be4dd9c3aecdbf49ded431c6 (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
30
31
32
userland: "15.1-RELEASE"
devfs_ruleset: 5

zfs:
  - name: postgres_data
    owner: "770"
    group: "770"
    mode: "0755"

nullfs:
  - src: postgres_data
    dst: /var/db/postgres

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;"