Sirius
IImmich
•Created by Sirius on 5/23/2025 in #help-desk-support
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
52 replies