Matt Comments - Answer Overflow

Matt

•Created by Matt on 4/30/2025 in #help-desk-support

Postgres error during migrations

yeah good call, I think I had not installed pgvecto.rs properly or something. It's a shared postgres instance so I was hoping to add an immich db to it, but instead I just spun up a dedicated immich postgres with the official pgvecto.rs image instead of my custom postgres image, and it is working now 🎉 Thanks a lot for your help

15 replies

IImmich

•Created by Matt on 4/30/2025 in #help-desk-support

Postgres error during migrations

Just raw Postgres in a statefulset with a longhorn PVC

15 replies

IImmich

•Created by Matt on 4/30/2025 in #help-desk-support

Postgres error during migrations

Also in kubernetes, so I wrote a docker image that looks like this (following the pgvectors docs on installing via a deb package): FROM postgres:16-bullseye RUN wget https://github.com/tensorchord/pgvecto.rs/releases/download/v0.3.0/vectors-pg16_0.3.0_amd64.deb RUN apt install -y ./vectors-pg16_0.3.0_amd64.deb

15 replies

IImmich

•Created by Matt on 4/30/2025 in #help-desk-support

Postgres error during migrations

I'm attempting to use the immich helm chart to deploy immich on kubernetes. Here is my values.yaml:

env:
  REDIS_HOSTNAME: '(ip)'
  DB_HOSTNAME: '(ip)'
  DB_USERNAME: "immich"
  DB_DATABASE_NAME: "immich"
  DB_PASSWORD:
    valueFrom:
      secretKeyRef:
        name: db-password
        key: password

image:
  tag: release

immich:
  metrics:
    enabled: false
  persistence:
    library:
      existingClaim: 'immich-pvc'

  configuration: {}

postgresql:
  global:
    postgresql:
      auth:
        existingSecret: "db-password"

redis:
  enabled: false

server:
  enabled: true
  image:
    repository: ghcr.io/immich-app/immich-server
    pullPolicy: IfNotPresent
  ingress:
    main:
      enabled: false

machine-learning:
  enabled: false

global:
  postgresql:
    auth:
      existingSecret: db-password
      secretKeys:
        userPasswordKey: password

env:
  REDIS_HOSTNAME: '(ip)'
  DB_HOSTNAME: '(ip)'
  DB_USERNAME: "immich"
  DB_DATABASE_NAME: "immich"
  DB_PASSWORD:
    valueFrom:
      secretKeyRef:
        name: db-password
        key: password

image:
  tag: release

immich:
  metrics:
    enabled: false
  persistence:
    library:
      existingClaim: 'immich-pvc'

  configuration: {}

postgresql:
  global:
    postgresql:
      auth:
        existingSecret: "db-password"

redis:
  enabled: false

server:
  enabled: true
  image:
    repository: ghcr.io/immich-app/immich-server
    pullPolicy: IfNotPresent
  ingress:
    main:
      enabled: false

machine-learning:
  enabled: false

global:
  postgresql:
    auth:
      existingSecret: db-password
      secretKeys:
        userPasswordKey: password

15 replies

Gaming

Programming