[Nest] 7 - 06/01/2025, 6:39:16 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'
}
[Nest] 7 - 06/01/2025, 6:39:16 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'
}