© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
ImmichI
Immich•10mo ago•
9 replies
Jonsch

PostgresError: operator does not exists

Hi I am trying to setup immich on k8s with cloudnative-pg I have followed this blog and followed the issues found in the helm repo.

---
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: immich-pg
  namespace: immich
spec:
  instances: 2
  bootstrap:
    initdb:
      database: immich
      owner: immich
      postInitSQL:
        - CREATE EXTENSION IF NOT EXISTS "vectors";
        - CREATE EXTENSION IF NOT EXISTS "cube" CASCADE;
        - CREATE EXTENSION IF NOT EXISTS "earthdistance" CASCADE;
  storage:
    size: 5Gi
  imageName: ghcr.io/tensorchord/cloudnative-pgvecto.rs:16.5-v0.3.0
  managed:
    roles:
      - name: immich
        superuser: true
        login: true
  postgresql:
    shared_preload_libraries:
      - "vectors.so"
---
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: immich-pg
  namespace: immich
spec:
  instances: 2
  bootstrap:
    initdb:
      database: immich
      owner: immich
      postInitSQL:
        - CREATE EXTENSION IF NOT EXISTS "vectors";
        - CREATE EXTENSION IF NOT EXISTS "cube" CASCADE;
        - CREATE EXTENSION IF NOT EXISTS "earthdistance" CASCADE;
  storage:
    size: 5Gi
  imageName: ghcr.io/tensorchord/cloudnative-pgvecto.rs:16.5-v0.3.0
  managed:
    roles:
      - name: immich
        superuser: true
        login: true
  postgresql:
    shared_preload_libraries:
      - "vectors.so"


The main things work except the ml jobs and searching then I get the error in the server:

[Nest] 8  - 05/06/2025, 9:30:36 PM   ERROR [Microservices:{"id":"d65ceb22-7696-4cef-bc3d-cdcd19a8d615","source":"upload"}] Unable to run job handler (duplicateDetection/duplicate-detection): PostgresError: operator does not exist: vectors.vector <=> unknown
PostgresError: operator does not exist: vectors.vector <=> unknown
    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)
    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)
    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)
[Nest] 8  - 05/06/2025, 9:30:36 PM   ERROR [Microservices:{"id":"d65ceb22-7696-4cef-bc3d-cdcd19a8d615","source":"upload"}] Unable to run job handler (duplicateDetection/duplicate-detection): PostgresError: operator does not exist: vectors.vector <=> unknown
PostgresError: operator does not exist: vectors.vector <=> unknown
    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)
    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)
    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
    at Socket.emit (node:events:518:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
    at TCP.callbackTrampoline (node:internal/async_hooks:130:17)


had anybody anything similar or should I create an issue?
🏡 Frank Zhao
Immich
Notes on deploying Immich on k3s Kubernetes. I use the community Immich Helm chart with Cloudnative Postgres . Pre-requisites Set up Postgres When using the community Immich helm chart, the postgres subchart is deprecated, so we will need to set up our own postgres instances for Immich.
ImmichJoin
A place to hang out, get support, discuss Immich, get announcements about releases and anything else going on.
36,590Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

PostgresError: column assets.isVisible does not exist
ImmichIImmich / help-desk-support
8mo ago
PostgresError:
ImmichIImmich / help-desk-support
9mo ago
postgreserror isVisible
ImmichIImmich / help-desk-support
7mo ago
PostgresError: password authentication.
ImmichIImmich / help-desk-support
5mo ago