ImmichI
Immich8mo ago
6 replies
Den

Please ensure the Postgres instance has VectorChord installed.

I'm upgrading from 1.332, and after changing in docker compose the database image:
database:
container_name: immich_postgres
image: ghcr.io/immich-app/postgres:14-vectorchord0.3.0-pgvectors0.2.0

And redownloading images, I start recieving an error:
[Nest] 7 - 05/22/2025, 12:56:23 PM FATAL [Microservices:DatabaseService] Failed to activate VectorChord extension.
Please ensure the Postgres instance has VectorChord installed.

If the Postgres instance already has VectorChord installed, Immich may not have the necessary permissions to activate it.
In this case, please run 'CREATE EXTENSION IF NOT EXISTS vchord CASCADE' manually as a superuser.
See https://immich.app/docs/guides/database-queries for how to query the database.
PostgresError: vchord must be loaded via shared_preload_libraries.

And immich-server pod is always restarting.
Was this page helpful?