Immich

https://immich.app/

see https://docs.immich.app/administration/backup-and-restore/

• database
• file system

observed during first startup that postgrres container would log the follosing:

immich_postgres  | 2026-02-25 19:15:33.917 UTC [92] ERROR:  relation "system_metadata" does not exist at character 21
immich_postgres  | 2026-02-25 19:15:33.917 UTC [92] STATEMENT:  select "value" from "system_metadata" where "key" = $1

Only direct mention of this found here: old.reddit.com/r/immich/comments/19bfv27/database_errors_immich_swarm_not_able_to_start/

Cause unknown - tried to reproduce by deploying with all defaults - error does not show up consistently and only on first startup.

Checking inside db container shows the table gets created fine:

carl@bay-21:~$ docker exec -it immich_postgres psql -U postgres
postgres-# \du
                                   List of roles
 Role name |                         Attributes                         | Member of 
-----------+------------------------------------------------------------+-----------
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres-# \l
                                 List of databases
   Name    |  Owner   | Encoding |  Collate   |   Ctype    |   Access privileges   
-----------+----------+----------+------------+------------+-----------------------
 immich    | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 
 postgres  | postgres | UTF8     | en_US.utf8 | en_US.utf8 | 
 template0 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.utf8 | en_US.utf8 | =c/postgres          +
           |          |          |            |            | postgres=CTc/postgres
(4 rows)

postgres=# \c immich 
You are now connected to database "immich" as user "postgres".
immich=# \dt
immich=# select * from system_metadata;
           key           |                                                            value                                                            
-------------------------+-----------------------------------------------------------------------------------------------------------------------------
 system-flags            | {"mountChecks": {"thumbs": true, "upload": true, "backups": true, "library": true, "profile": true, "encoded-video": true}}
 MediaLocation           | {"location": "/data"}
 reverse-geocoding-state | {"lastUpdate": "2026-03-25T17:13:19+00:00", "lastImportFileName": "cities500.txt"}
 version-check-state     | {"checkedAt": "2026-05-31T19:21:33.627Z", "releaseVersion": "v2.7.5"}
(4 rows)

Dismissing for now - 2026-05-31.

see https://github.com/immich-app/immich/issues/27274

Fails when using SMTPS over port 2525 - smtp2go does offer TLS over that port - but works with port 465: