error during immich database restore

[alocin73]

Hi all,

i've installed immich lxc and was tring to restore the old database backup.

It stop with this error:
Error: /usr/lib/postgresql/16/bin/psql non-zero exit code (3)
ERROR: extension "vectors" is not available
DETAIL: Could not open extension control file "/usr/share/postgresql/16/extension/vectors.control": No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.

The file exist but is vector.control

Renamed the file in vectors.control, new error:
Error: /usr/lib/postgresql/16/bin/psql non-zero exit code (3)
ERROR: extension "vectors" has no installation script nor update path for version "0.8.2"

Renamed the file vector--0.8.2.sql in vectors--0.8.2.sql one step further, start the backup restore but it doesn't finish:

Error: /usr/lib/postgresql/16/bin/psql non-zero exit code (3)
ERROR: access method "vectors" does not exist

can anyone help?

thank you

[vhsdream]

Hi @alocin73

Is the DB restore from a previous LXC installation, or is it from a Docker install or something else?

Can you run this in your Immich LXC?

sudo -u postgres psql -d immich -c '\dx'

Share the results here.

[alocin73]

Backup came from a docker install.

The output from the command above Is:
List of installed extensions Name | Version | Schema | Description ---------------+---------+------------+--------------------------------------------------------------------------------------------- cube | 1.5 | public | data type for multidimensional cubes earthdistance | 1.2 | public | calculate great-circle distances on the surface of the Earth pg_trgm | 1.6 | public | text similarity measurement and index searching based on trigrams plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language unaccent | 1.1 | public | text search dictionary that removes accents uuid-ossp | 1.1 | public | generate universally unique identifiers (UUIDs) vchord | 0.5.3 | public | vchord: Vector database plugin for Postgres, written in Rust, specifically designed for LLM vector | 0.8.2 | public | vector data type and ivfflat and hnsw access methods (8 rows)

[alocin73]

Answering from mobile i'm not able ti properly format the text

[vhsdream]

What about your postgresql.conf file in /etc/postgresql/16/main? What do you have on line 747 where it says shared_preload_libraries?

I want you to be aware that we do not currently support or recommend restoring DB backups that come from a Docker installation. But it looks like your DB dump from that install might have been using a different Vector extension and therefore isn't compatible with the DB schema for the LXC install.

You might be able to fix this yourself by consulting the documentation but you do so at your own risk.

[alocin73]

Thanks for looking at this, i was not aware of that change in immich.

I will look at the documentation and eventually do it the manual way.

Thanks again.

Nicola

[Se7enair]

Did you found a way? I have the same problem...
Did the manual way worked?

[Se7enair]

Ok, I found the problem on my setup.
There were old entries in the backup from vectors. Immich 3.0.1 uses a different version. I deleted them from the backup and where able to restore it.