Trying to install VectorChord in postgres 15 docker container
❓Question
I am using unraid. I installed immich through the unraid app store not docker compose. I changed my postgres repo from:tensorchord/pgvecto-rs:pg15-v0.2.0 to:ghcr.io/immich-app/postgres:15-vectorchord0.5.3-pgvector0.8.1. I spent time trying to work through various errors and version mismatches. I am back on tensorchord/pgvecto-rs:pg15-v0.2.0. but immich says it is running at version 2.5.3. I don't have vectorchord installed in my postgres database as I am using the old repo.
I type \dx and get the following:
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)
That confirms I don't have vectorchord installed.
When I try to use the newer postgres repo I get version errors because I think I tried to use a repo with vectorchord 0.5.3 and pgvector 0.8.1. It couldn't migrate because I was on pgvector-rs 0.2.0. Now when I try to use ghcr.io/immich-app/postgres:15-vectorchord0.3.0-pgvectors0.2.0 i get errors saying I need vectorchord 0.5.3.
In conclusion, I seem to be stuck unable to migrate to vectorchord 0.3 because something is expecting 0.5.3 but I cant migrate to 0.5.3 because I don't have pgvector 0.8.1. I can access immich in a web browser and on the mobile app. Photos also still get uploaded.
I type \dx and get the following:
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 row)
That confirms I don't have vectorchord installed.
When I try to use the newer postgres repo I get version errors because I think I tried to use a repo with vectorchord 0.5.3 and pgvector 0.8.1. It couldn't migrate because I was on pgvector-rs 0.2.0. Now when I try to use ghcr.io/immich-app/postgres:15-vectorchord0.3.0-pgvectors0.2.0 i get errors saying I need vectorchord 0.5.3.
In conclusion, I seem to be stuck unable to migrate to vectorchord 0.3 because something is expecting 0.5.3 but I cant migrate to 0.5.3 because I don't have pgvector 0.8.1. I can access immich in a web browser and on the mobile app. Photos also still get uploaded.
