mirror of
https://github.com/rubenhensen/k8scd.git
synced 2026-11-15 22:29:09 +01:00
64 lines
1.7 KiB
YAML
64 lines
1.7 KiB
YAML
apiVersion: postgresql.cnpg.io/v1
|
|
kind: Cluster
|
|
metadata:
|
|
name: immich-postgres-17
|
|
namespace: immich
|
|
spec:
|
|
instances: 1
|
|
|
|
# CNPG image with VectorChord and pgvector, which immich 2.x and 3.x use
|
|
# for its vector indexes (pgvecto.rs is gone in immich 3.0).
|
|
imageName: ghcr.io/tensorchord/cloudnative-vectorchord:17.11-1.1.1
|
|
resources:
|
|
requests:
|
|
cpu: 20m
|
|
memory: 320Mi
|
|
limits:
|
|
memory: 1Gi
|
|
|
|
postgresql:
|
|
shared_preload_libraries:
|
|
- "vchord.so"
|
|
|
|
# WAL archiving and base backups to Garage, see postgresql-backup.yaml
|
|
plugins:
|
|
- name: barman-cloud.cloudnative-pg.io
|
|
isWALArchiver: true
|
|
parameters:
|
|
barmanObjectName: immich-postgres-17
|
|
|
|
# Filled once from the PostgreSQL 14 cluster (immich-postgres) after its
|
|
# embedding columns were turned into real[] and pgvecto.rs was dropped,
|
|
# see docs/upgrade-k8s-1.33.md.
|
|
bootstrap:
|
|
initdb:
|
|
database: immich
|
|
owner: immich
|
|
import:
|
|
type: microservice
|
|
databases:
|
|
- immich
|
|
source:
|
|
externalCluster: immich-postgres
|
|
postImportApplicationSQL:
|
|
- CREATE EXTENSION IF NOT EXISTS vchord CASCADE;
|
|
- ALTER TABLE public.smart_search ALTER COLUMN embedding SET DATA TYPE vector(512);
|
|
- ALTER TABLE public.face_search ALTER COLUMN embedding SET DATA TYPE vector(512);
|
|
# immich manages its own extensions and migrations
|
|
- ALTER USER immich WITH SUPERUSER;
|
|
|
|
externalClusters:
|
|
- name: immich-postgres
|
|
connectionParameters:
|
|
host: immich-postgres-rw
|
|
user: immich
|
|
dbname: immich
|
|
sslmode: require
|
|
password:
|
|
name: immich-postgres-app
|
|
key: password
|
|
|
|
storage:
|
|
size: 20Gi
|
|
storageClass: longhorn
|