Failed to activate VectorChord extension. Please ensure the Postgres instance has VectorChord in
Hello i migrate my docker compose .yml to the new image.
When immich_server start i have this error :
Nest] 7 - 05/22/2025, 8:12:07 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.
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) {
severity_local: 'ERROR',
severity: 'ERROR',
code: 'XX000',
file: 'lib.rs',
line: '15',
routine: 'vchord::_PG_init::_PG_init_inner'
}
So i use the docker exec to enter into the docker database container and i type :
CREATE EXTENSION IF NOT EXISTS vchord CASCADE;
This give me :
ERROR: vchord must be loaded via shared_preload_libraries.
How can i debug this ?
Thank you
When immich_server start i have this error :
Nest] 7 - 05/22/2025, 8:12:07 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.
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) {
severity_local: 'ERROR',
severity: 'ERROR',
code: 'XX000',
file: 'lib.rs',
line: '15',
routine: 'vchord::_PG_init::_PG_init_inner'
}
So i use the docker exec to enter into the docker database container and i type :
CREATE EXTENSION IF NOT EXISTS vchord CASCADE;
This give me :
ERROR: vchord must be loaded via shared_preload_libraries.
How can i debug this ?
Thank you
