ImmichI
Immich8mo ago
51 replies
Sirius

Error: The pgvecto.rs extension is not available inthis Postgres instance.

Running postgresql:17 on another machine

Installed vchord and required vector extension.

Using DB_URL='postgresql://immich:<password redacted>@10.5.0.111:5432/immich_db'

DB user immich
DB owner immich
DB name immich_db

User immich has superuser permissions

Extensions installed and attached to immich_db
Vchord
Vector

My understand was if you used vchord pgvecto.rs was not required. I've tried using DB_VECTOR_EXTENSION=vectorchord and [vectorchord] in the .env and the compose file. Which throws a bad variable.

I'm not sure on next steps. 17 doesnt have a 3.0 pgvector.rs and installing 4.0 throws a bad version.

Location in .env which I've commented out and left in with same result.
DB_DATA_LOCATION=postgresql.cffn.us:/data/dbs/immich/postgresql
Was this page helpful?