Arch Linux User Repository

Upgrading to postgresql-17 is awkward because of pgvecto.rs if you have been using 0.2.0 as provided by AUR package pgvecto.rs-immich. If you have been using 0.3.0 as provided by AUR package pgvecto.rs-immich-bin then these extra steps are likely not required and I suggest the wiki instructions for upgrades for major version increments of postgresql are followed.

If you would like to stick at postgresql-16 please add the following to pacman.conf:

IgnorePkgs = postgresql postgresql-libs

Following the manual dump and reload in the wiki does appear to work, with a few extra steps to consider the pgvecto.rs upgrade.

Starting point is postgresql-old-upgrade installed with pgvector.rs-0.2.0. Symlink the installation outputs of pgvecto.rs into the directories used by the parallel installation of postgresql-old-upgrade.

ln -s /usr/share/postgresql/extension/vectors.control /opt/pgsql-16/share/extension/vectors.control
ln -s /usr/share/postgresql/extension/vectors--0.2.0.sql /opt/pgsql-16/share/extension/vectors--0.2.0.sql
ln -s /usr/lib/postgresql/vectors.so /opt/pgsql-16/lib/vectors.so

Then perform the database start (/opt/psql-16/bin/pg_ctl .. start), "dump" (pg_dumpall...) and database stop (/opt/psql-16/bin/pg_ctl .. start) steps in the wiki.

Upgrade to postgresql-17 and pgvecto.rs-0.3.0 (provided by pgvector.rs-immich-bin). Clear out /var/lib/postgresql/data then initialise the database (initdb...) as per the wiki.

Start the service using systemctl start postgresql and install the pgvecto.rs using the following command:

psql -c 'ALTER SYSTEM SET shared_preload_libraries = "vectors.so"'

Finally restart the postgresql service and perform the reload (psql...) steps in the wiki.

EDITED: Various clarifications

From v1.111.0, this package does not build with nodejs < v20.

Latest (1.133) version introduced migration from pgvecto.rs to vchord database extension. For it to work, pgvector is also needed. Similarly to vectors, vchord must be preloaded via the postgres config.

Also, since valkey is now the default, perhaps the service file should reflect that as well.

Only machine-learning/immich_ml/log_conf.json is needed since 1.131, as immich_ml is now part of the virtual environment. Alternatively, /opt/immich-machine-learning/venv/lib/python3.12/site-packages/immich_ml/log_conf.json could be used directly.

I'm new to this and I'm having a problem installing the app. Issue is really a dependency.

Immich > pgvecto.rs>clang16>llvm16

When compiling, I get the error: signature not found

Thanks hrdl - much appreciated. I've used your patch verbatim for now!

immich 1.130 switched to uv, which changes the tooling a bit. python 3.13 is not supported yet as some of the dependencies are pinned to older versions, but python 3.12 still works. I'm sure there's room for improvement, but https://paste.sr.ht/~hrdl/a57fb8dfdb3a292f9181b78daa9e29a415ff510f is at least a start to avoid duplicate work.

Running command "/home/simona/.rustup/toolchains/nightly-2024-01-14-x86_64-unknown-linux-gnu/bin/cargo" "build" "--release" "--features" "pg17" "--no-default-features" "--message-format=json-render-diagnostics" error: none of the selected packages contains these features: pg17, did you mean: pg12, pg13, pg14, pg15, pg16?

I'm unable to start my immich server due to the following error around the upload/encoded-video/.immich file

Jan 27 21:00:07 desktop immich-server[1494334]: [Nest] 1494334  - 01/27/2025, 9:00:07 PM     LOG [Api:StorageService] Verifying system mount folder checks, current state: {"mountChecks":{"thumbs":true,"upload":true,"backups":true,"library":true,"profile":true,"encoded-video":true}}
Jan 27 21:00:07 desktop immich-server[1494334]: [Nest] 1494334  - 01/27/2025, 9:00:07 PM   ERROR [Api:StorageService] Failed to write /mnt/storage/Servers/immich-media/upload/encoded-video/.immich: Error: EROFS: read-only file system, open '/mnt/storage/Servers/immich-media/upload/encoded-video/.immich'

I'm running a ZFS pool that these files are stored on. It was working at install, but after an update a month or so ago, it hasn't worked. I also had some trouble with the postgres update, and I've reinstalled it a couple times, so maybe one of my configs got out of wack, but I'd be happy to see if there's any ideas as to what might be causing this.

EDIT: I had to update the service file with the new path with the following change using systemctl edit immich-server.service:

[Service]
ReadWritePaths=/tmp /var/tmp /mnt/storage/Servers/immich-media/upload

Upgrading to postgresql-17 is awkward because of pgvecto.rs if you have been using 0.2.0 as provided by AUR package pgvecto.rs-immich. If you have been using 0.3.0 as provided by AUR package pgvecto.rs-immich-bin then these extra steps are likely not required and I suggest the wiki instructions for upgrades for major version increments of postgresql are followed.

If you would like to stick at postgresql-16 please add the following to pacman.conf:

IgnorePkgs = postgresql postgresql-libs

Following the manual dump and reload in the wiki does appear to work, with a few extra steps to consider the pgvecto.rs upgrade.

Starting point is postgresql-old-upgrade installed with pgvector.rs-0.2.0. Symlink the installation outputs of pgvecto.rs into the directories used by the parallel installation of postgresql-old-upgrade.

ln -s /usr/share/postgresql/extension/vectors.control /opt/pgsql-16/share/extension/vectors.control
ln -s /usr/share/postgresql/extension/vectors--0.2.0.sql /opt/pgsql-16/share/extension/vectors--0.2.0.sql
ln -s /usr/lib/postgresql/vectors.so /opt/pgsql-16/lib/vectors.so

Then perform the database start (/opt/psql-16/bin/pg_ctl .. start), "dump" (pg_dumpall...) and database stop (/opt/psql-16/bin/pg_ctl .. start) steps in the wiki.

Upgrade to postgresql-17 and pgvecto.rs-0.3.0 (provided by pgvector.rs-immich-bin). Clear out /var/lib/postgresql/data then initialise the database (initdb...) as per the wiki.

Start the service using systemctl start postgresql and install the pgvecto.rs using the following command:

psql -c 'ALTER SYSTEM SET shared_preload_libraries = "vectors.so"'

Finally restart the postgresql service and perform the reload (psql...) steps in the wiki.

EDITED: Various clarifications

Just removed my forced downgrade, and had postgresql-old-upgrade installed. This fixed the upgrade issue I had before. It handled the upgrade process on the fly when upgrading :) All good now.

[EDIT] Seems like it didn't work after a reboot. Still version error, and run into same issue as @CountMurphy when trying to upgrade the database. Postgresql is a but of a nightmare to work with it seems.

Has anyone got the upgrade to work? I've updated the pgvecto.rs-immich-bin for postgres 17, copied the old vectors.so into /opt/pgsql-16/lib, but when I run pg_upgrade I get

pg_restore: error: could not execute query: ERROR: could not find function "_vectors_vecf16_operator_cosine_wrapper" in file "/usr/lib/postgresql/vectors.so"

Never had to upgrade postgres before, so might be missing something basic?

EDIT: Update was successful using the manual dump and reload method