Sirius
Sirius
PostsComments
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
So the steps to my solution were to: 1. Pull latest docker-compose.yml and .env. delete postgres and redis containers and set .env variables for DB_URL and REDIS variables. 2. Set the version in .env to the most recent version (resulted in vchord needs to be added to shared_preload_libraries error) 3. Confirmed vchord was in the shared_preload in postgres.conf. login to db as superuser and ALTER SYSTEM shared_preload_libraries TO vchord 4. Started redis as it then threw a redis noperm error Things that didn't work 1. Installing vecto.rs 2. Trying to install pgvector or vchord when they were already installed and showing as active in the db. 3. Using DB_VECTOR_EXTENSION
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
This is the version that -release pulled Immich v1.132.3
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
Ok so the version was the issue. I changed the version from the default release to v1.133.0 it pulled everything again. Then it threw a shared preload libraries vchord code i had to login and alter database since it wasnt using the config file. Once I set shared libraries and reset and and started my redis (didnt start automatically) it inititialized everything and i have login
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
I can pin the install image but it is a new install so i can't imagine the docker compose yml pulling a different version when instructed to use release
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
Vector, vchord, vecto.rs. maybe thats the issue. I thought the vector and pgvector were the same because they were v8.0 I'll add that and see if i get a change.
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
immich_server            | [Nest] 7  - 05/23/2025, 10:05:43 AM     LOG [Microservices:DatabaseRepository] Running migrations, this may take a while
immich_server            | [Nest] 17  - 05/23/2025, 10:05:43 AM     LOG [Api:EventRepository] Initialized websocket server
immich_server            | Query failed : {
immich_server            |   durationMs: 1.132673000000068,
immich_server            |   error: PostgresError: operator class "vector_cos_ops" does not exist for access method "vectors"
immich_server            |       at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)
immich_server            |       at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)
immich_server            |       at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
immich_server            |       at Socket.emit (node:events:518:28)
immich_server            |       at addChunk (node:internal/streams/readable:561:12)
immich_server            |       at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
immich_server            |       at Readable.push (node:internal/streams/readable:392:5)
immich_server            |       at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
immich_server            |     severity_local: 'ERROR',
immich_server            |     severity: 'ERROR',
immich_server            |     code: '42704',
immich_server            |     file: 'indexcmds.c',
immich_server            |     line: '2239',
immich_server            |     routine: 'ResolveOpClass'
immich_server            |   },
immich_server            |   sql: 'CREATE INDEX "face_index" ON "face_search" USING hnsw (embedding vector_cosine_ops) WITH (ef_construction = 300, m = 16)',
immich_server            |   params: []
immich_server            | }
immich_server            | [Nest] 7  - 05/23/2025, 10:05:43 AM     LOG [Microservices:DatabaseRepository] Running migrations, this may take a while
immich_server            | [Nest] 17  - 05/23/2025, 10:05:43 AM     LOG [Api:EventRepository] Initialized websocket server
immich_server            | Query failed : {
immich_server            |   durationMs: 1.132673000000068,
immich_server            |   error: PostgresError: operator class "vector_cos_ops" does not exist for access method "vectors"
immich_server            |       at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)
immich_server            |       at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)
immich_server            |       at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)
immich_server            |       at Socket.emit (node:events:518:28)
immich_server            |       at addChunk (node:internal/streams/readable:561:12)
immich_server            |       at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
immich_server            |       at Readable.push (node:internal/streams/readable:392:5)
immich_server            |       at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
immich_server            |     severity_local: 'ERROR',
immich_server            |     severity: 'ERROR',
immich_server            |     code: '42704',
immich_server            |     file: 'indexcmds.c',
immich_server            |     line: '2239',
immich_server            |     routine: 'ResolveOpClass'
immich_server            |   },
immich_server            |   sql: 'CREATE INDEX "face_index" ON "face_search" USING hnsw (embedding vector_cosine_ops) WITH (ef_construction = 300, m = 16)',
immich_server            |   params: []
immich_server            | }
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
Did a fresh yml and .env. going to setup the db image in my postgresql now because it still doesn't like it
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
right but when I install vecto.rs 3.0 it moves beyond that error.
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
I do wonder if it's looking for vector.rs as it's still in the dockerfile and is the only one I'm missing. When I installed vector.rs 4.0 it told me the version isn't supported which makes sense as 3.0 is the latest version listed in the postgres dockerfile versions.yml
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
I'm going to start with brand new install with the compose and env changing the DB_URL and set up the postgres image on the postgresql17 database.
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
right
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
but modify to postgres:17-vectorchord0.3.0-pgvectors0.2.0
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
My thought is I have the DB_URL in server; if I'm doing a fresh install and pointing to DB URL it should go here: database: container_name: immich_postgres image: ghcr.io/immich-app/postgres:14-vectorchord0.3.0-pgvectors0.2.0 environment: DB_URL='postgresql://immich:<redacted>@10.5.0.111:5432/immich_db' 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 restart: always
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
fresh install with -release image
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
it's a new install. and I went through the https://immich.app/docs/administration/postgres-standalone/
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
that gives me the issue of not having pgvecto.rs available
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
LOG [Microservices:EventRepository] Initialized websocket server immich | Error: The pgvecto.rs extension is not available in this Postgres instance. immich | If using a container image, ensure the image has the extension installed. immich | at /usr/src/app/dist/services/database.service.js:70:23 immich | at process.processTicksAndRejections (node:internal/process/task_queues:105:5) immich | at async /usr/src/app/dist/repositories/database.repository.js:250:27 immich | at async /usr/src/app/node_modules/kysely/dist/cjs/kysely.js:535:20 immich | at async DefaultConnectionProvider.provideConnection (/usr/src/app/node_modules/kysely/dist/cjs/driver/default-connection-provider.js:12:20) immich | at async /usr/src/app/dist/repositories/database.repository.js:247:13
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
immich_db-# \du List of roles Role name | Attributes
-----------+------------------------------------------------------------ immich | Superuser, Create role, Create DB, Replication, Bypass RLS postgres | Superuser, Create role, Create DB, Replication, Bypass RLS
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
Logged in to the immich_db:
List of installed extensions Name | Version | Schema | Description
---------+---------+------------+--------------------------------------------------------------------------------------------- plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language vchord | 0.3.0 | public | vchord: Vector database plugin for Postgres, written in Rust, specifically designed for LLM vector | 0.8.0 | public | vector data type and ivfflat and hnsw access methods
52 replies
IImmich
Created by Sirius on 5/23/2025 in #help-desk-support
Error: The pgvecto.rs extension is not available inthis Postgres instance.
full error: with DB_extension set: immich | /usr/src/app/dist/repositories/config.repository.js:44 immich | throw new Error(Invalid environment variables: ${errors.map((error) => ${error.property}=${error.value}).join(', ')}); immich | ^ immich | immich | Error: Invalid environment variables: DB_VECTOR_EXTENSION=vectorchord immich | at getEnv (/usr/src/app/dist/repositories/config.repository.js:44:15) immich | at ConfigRepository.getEnv (/usr/src/app/dist/repositories/config.repository.js:199:22) immich | at Object.<anonymous> (/usr/src/app/dist/app.module.js:52:56) immich | at Module._compile (node:internal/modules/cjs/loader:1554:14) immich | at Object..js (node:internal/modules/cjs/loader:1706:10) immich | at Module.load (node:internal/modules/cjs/loader:1289:32) immich | at Function._load (node:internal/modules/cjs/loader:1108:12) immich | at TracingChannel.traceSync (node:diagnostics_channel:322:14) immich | at wrapModuleLoad (node:internal/modules/cjs/loader:220:24) immich | at Module.require (node:internal/modules/cjs/loader:1311:12) immich | immich | Node.js v22.14.0
52 replies