u/AnswerGlittering1811

Edit - Fixed the issue

Hi all initially , tried pulling V3 immich server. Failed then came thur this forum and changes the postgres to vector chord and still it is failing.

 image: ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0@sha256:bcf63357191b76a916ae5eb93464d65c07511da41e3bf7a8416db519b40b1c23 or

image: ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0 still failin.

postgress log i think
2026-07-03 16:08:36.396 UTC [1] LOG: starting PostgreSQL 14.19 (Debian 14.19-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
2026-07-03 16:08:36.397 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2026-07-03 16:08:36.397 UTC [1] LOG: listening on IPv6 address "::", port 5432
2026-07-03 16:08:37.318 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2026-07-03 16:08:37.448 UTC [33] LOG: database system was shut down at 2026-07-03 15:56:45 UTC
[2026-07-03T16:08:37Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332".
[2026-07-03T16:08:37Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17576".
[2026-07-03T16:08:37Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17576/segments/33adeae6-fa84-42bc-b93c-2bf704b7a39c".
2026-07-03 16:08:40.006 UTC [1] LOG: database system is ready to accept connections
[2026-07-03T16:08:40Z INFO service::utils::clean] Find directory "pg_vectors/indexes/17332/segments/6a1c0349-f1d8-4e0f-a30e-076e9ab8ca61".
2026-07-03 16:09:03.700 UTC [54] ERROR: vchord must be loaded via shared_preload_libraries.
2026-07-03 16:09:03.700 UTC [54] STATEMENT: CREATE EXTENSION IF NOT EXISTS vchord CASCADE
2026-07-03 16:09:18.443 UTC [58] ERROR: vchord must be loaded via shared_preload_libraries.
2026-07-03 16:09:18.443 UTC [58] STATEMENT: CREATE EXTENSION IF NOT EXISTS vchord CASCADE
2026-07-03 16:09:33.670 UTC [62] ERROR: vchord must be loaded via shared_preload_libraries.
2026-07-03 16:09:33.670 UTC [62] STATEMENT: CREATE EXTENSION IF NOT EXISTS vchord CASCADE
2026-07-03 16:09:47.579 UTC [67] ERROR: vchord must be loaded via shared_preload_libraries.
2026-07-03 16:09:47.579 UTC [67] STATEMENT: CREATE EXTENSION IF NOT EXISTS vchord CASCADE
2026-07-03 16:10:02.451 UTC [71] ERROR: vchord must be loaded via shared_preload_libraries.
2026-07-03 16:10:02.451 UTC [71] STATEMENT: CREATE EXTENSION IF NOT EXISTS vchord CASCADE
2026-07-03 16:10:16.832 UTC [75] ERROR: vchord must be loaded via shared_preload_libraries.
2026-07-03 16:10:16.832 UTC [75] STATEMENT: CREATE EXTENSION IF NOT EXISTS vchord CASCADE

immich server error
immich_server
date,stream,content
2026/07/03 12:10:16,stderr,Killing api process

2026/07/03 12:10:16,stderr,microservices worker exited with code 1

2026/07/03 12:10:16,stderr, at TCP.onStreamRead (node:internal/stream_base_commons:189:23)

2026/07/03 12:10:16,stderr, at Readable.push (node:internal/streams/readable:394:5)

2026/07/03 12:10:16,stderr, at readableAddChunkPushByteMode (node:internal/streams/readable:514:3)

2026/07/03 12:10:16,stderr, at addChunk (node:internal/streams/readable:563:12)

2026/07/03 12:10:16,stderr, at Socket.emit (node:events:508:28)

2026/07/03 12:10:16,stderr, at Socket.data (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.9/node_modules/postgres/src/connection.js:324:9)

2026/07/03 12:10:16,stderr, at handle (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.9/node_modules/postgres/src/connection.js:489:6)

2026/07/03 12:10:16,stderr, at ErrorResponse (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.9/node_modules/postgres/src/connection.js:815:30)

2026/07/03 12:10:16,stderr,"microservices worker error: PostgresError: vchord must be loaded via shared_preload_libraries., stack: PostgresError: vchord must be loaded via shared_preload_libraries.
"
2026/07/03 12:10:16,stderr,}

2026/07/03 12:10:16,stderr, routine: 'vchord::_PG_init::_PG_init_inner'

2026/07/03 12:10:16,stderr," line: '28',
"
2026/07/03 12:10:16,stderr," file: 'lib.rs',
"
2026/07/03 12:10:16,stderr," code: 'XX000',
"
2026/07/03 12:10:16,stderr," severity: 'ERROR',
"
2026/07/03 12:10:16,stderr," severity_local: 'ERROR',
"
2026/07/03 12:10:16,stderr, at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {

2026/07/03 12:10:16,stderr, at Readable.push (node:internal/streams/readable:394:5)

2026/07/03 12:10:16,stderr, at readableAddChunkPushByteMode (node:internal/streams/readable:514:3)

2026/07/03 12:10:16,stderr, at addChunk (node:internal/streams/readable:563:12)

2026/07/03 12:10:16,stderr, at Socket.emit (node:events:508:28)

2026/07/03 12:10:16,stderr, at Socket.data (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.9/node_modules/postgres/src/connection.js:324:9)

2026/07/03 12:10:16,stderr, at handle (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.9/node_modules/postgres/src/connection.js:489:6)

2026/07/03 12:10:16,stderr, at ErrorResponse (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.9/node_modules/postgres/src/connection.js:815:30)

2026/07/03 12:10:16,stderr,PostgresError: vchord must be loaded via shared_preload_libraries.

2026/07/03 12:10:16,stdout, See https://docs.immich.app/guides/database-queries for how to query the database.

2026/07/03 12:10:16,stdout," In this case, please run 'CREATE EXTENSION IF NOT EXISTS vchord CASCADE' manually as a superuser.
"
2026/07/03 12:10:16,stdout," If the Postgres instance already has VectorChord installed, Immich may not have the necessary permissions to activate it.
"
2026/07/03 12:10:16,stdout,

2026/07/03 12:10:16,stdout, Please ensure the Postgres instance has VectorChord installed.

2026/07/03 12:10:16,stdout,"[Nest] 7 - 07/03/2026, 4:10:16 PM  FATAL [Microservices:DatabaseService] Failed to activate VectorChord extension.
"
2026/07/03 12:10:16,stderr,}

2026/07/03 12:10:16,stderr, params: []

2026/07/03 12:10:16,stderr," sql: 'CREATE EXTENSION IF NOT EXISTS vchord CASCADE',
"
2026/07/03 12:10:16,stderr," },
"
2026/07/03 12:10:16,stderr, routine: 'vchord::_PG_init::_PG_init_inner'

2026/07/03 12:10:16,stderr," line: '28',
"
2026/07/03 12:10:16,stderr," file: 'lib.rs',
"
2026/07/03 12:10:16,stderr," code: 'XX000',
"
2026/07/03 12:10:16,stderr," severity: 'ERROR',
"
2026/07/03 12:10:16,stderr," severity_local: 'ERROR',
"
2026/07/03 12:10:16,stderr, at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {

2026/07/03 12:10:16,stderr, at Readable.push (node:internal/streams/readable:394:5)

2026/07/03 12:10:16,stderr, at readableAddChunkPushByteMode (node:internal/streams/readable:514:3)

2026/07/03 12:10:16,stderr, at addChunk (node:internal/streams/readable:563:12)

2026/07/03 12:10:16,stderr, at Socket.emit (node:events:508:28)

2026/07/03 12:10:16,stderr, at Socket.data (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.9/node_modules/postgres/src/connection.js:324:9)

2026/07/03 12:10:16,stderr, at handle (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.9/node_modules/postgres/src/connection.js:489:6)

2026/07/03 12:10:16,stderr, at ErrorResponse (file:///usr/src/app/server/node_modules/.pnpm/postgres@3.4.9/node_modules/postgres/src/connection.js:815:30)

2026/07/03 12:10:16,stderr, error: PostgresError: vchord must be loaded via shared_preload_libraries.

2026/07/03 12:10:16,stderr," durationMs: 51.67609099999936,
"
2026/07/03 12:10:16,stderr,Query failed : {

2026/07/03 12:10:16,stdout,"[Nest] 7 - 07/03/2026, 4:10:16 PM  LOG [Microservices:DatabaseRepository] Creating VectorChord extension
"
2026/07/03 12:10:16,stdout,"[Nest] 7 - 07/03/2026, 4:10:16 PM  LOG [Microservices:WebsocketRepository] Initialized websocket server
"
2026/07/03 12:10:16,stderr,(Use \node --trace-warnings ...` to show where the warning was created)`

2026/07/03 12:10:16,stderr,(node:7) ExperimentalWarning: WASI is an experimental feature and might change at any time

2026/07/03 12:10:16,stderr,(Use \node --trace-warnings ...` to show where the warning was created)`

2026/07/03 12:10:16,stderr,(node:25) ExperimentalWarning: WASI is an experimental feature and might change at any time

2026/07/03 12:10:11,stdout,Starting microservices worker

2026/07/03 12:10:11,stdout,Starting api worker

2026/07/03 12:10:10,stderr,(Use \node --trace-warnings ...` to show where the warning was created)`

2026/07/03 12:10:10,stderr,(node:7) ExperimentalWarning: WASI is an experimental feature and might change at any time

2026/07/03 12:10:06,stdout,Detected CPU Cores: 4

2026/07/03 12:10:06,stdout,Initializing Immich v3.0.1

docker compose used
#
# WARNING: Make sure to use the docker-compose.yml of the current release:
#
# https://github.com/immich-app/immich/releases/latest/download/docker-compose.yml
#
# The compose file on main may not be compatible with the latest release.
#

name: immich

services:
immich-server:
container_name: immich_server
#image: ghcr.io/immich-app/immich-server:latest
#image: ghcr.io/immich-app/immich-server:v1.135.3
image: ghcr.io/immich-app/immich-server:release
extends:
file: hwaccel.transcoding.yml
service: quicksync # set to one of [nvenc, quicksync, rkmpp, vaapi, vaapi-wsl] for accelerated transcoding
volumes:
# Do not edit the next line. If you want to change the media storage location on your system, edit the value of UPLOAD_LOCATION in the .env file
- ${UPLOAD_LOCATION}:/usr/src/app/upload
- /etc/localtime:/etc/localtime:ro
- /volume1/homes/haripalat/Photos:/synologyphotoslibrary:ro
- ./config:/config
env_file:
- .env
ports:
- '2283:2283'
depends_on:
- redis
- database
restart: on-failure:5
healthcheck:
disable: false

immich-machine-learning:
container_name: immich_machine_learning
# For hardware acceleration, add one of -[armnn, cuda, openvino] to the image tag.
# Example tag: ${IMMICH_VERSION:-release}-cuda
#image: ghcr.io/immich-app/immich-machine-learning:v1.135.3
image: ghcr.io/immich-app/immich-machine-learning:release
# extends: # uncomment this section for hardware acceleration - see https://immich.app/docs/features/ml-hardware-acceleration
# file: hwaccel.ml.yml
# service: cpu # set to one of [armnn, cuda, openvino, openvino-wsl] for accelerated inference - use the \-wsl` version for WSL2 where applicablevolumes:- ./model-cache:/cacheenv_file:- .envrestart: on-failure:5healthcheck:disable: false`

redis:
container_name: immich_redis
image: docker.io/redis:6.2-alpine@sha256:2ba50e1ac3a0ea17b736ce9db2b0a9f6f8b85d4c27d5f5accc6a416d8f42c6d5
healthcheck:
test: redis-cli ping || exit 1
restart: on-failure:5

database:
container_name: immich_postgres
# image: docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0@sha256:90724186f0a3517cf6914295b5ab410db9ce23190a2d9d0b9dd6463e3fa298f0
image: ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0@sha256:bcf63357191b76a916ae5eb93464d65c07511da41e3bf7a8416db519b40b1c23
# image: ghcr.io/immich-app/postgres:14-vectorchord0.4.3-pgvectors0.2.0
environment:
POSTGRES_PASSWORD: ${DB_PASSWORD}
POSTGRES_USER: ${DB_USERNAME}
POSTGRES_DB: ${DB_DATABASE_NAME}
POSTGRES_INITDB_ARGS: '--data-checksums'
DB_STORAGE_TYPE: 'HDD'
volumes:
# Do not edit the next line. If you want to change the database storage location on your system, edit the value of DB_DATA_LOCATION in the .env file
- ${DB_DATA_LOCATION}:/var/lib/postgresql/data
command:
[
'postgres',
'-c',
'shared_preload_libraries=vectors.so',
'-c',
'search_path="$$user", public, vectors',
'-c',
'logging_collector=on',
'-c',
'max_wal_size=2GB',
'-c',
'shared_buffers=512MB',
'-c',
'wal_compression=on',
]
shm_size: 128mb
healthcheck:
disable: false
restart: on-failure:5