Immich broken after update

SpeeterYT · May 23, 2025, 9:30pm

I updated immich from casaos and the postresql db is broken. Here’s the log

PostgreSQL Database directory appears to contain a database; Skipping initialization

2025-05-23 21:26:37.927 GMT [1] LOG: skipping missing configuration file “/var/lib/postgresql/data/postgresql.override.conf”
2025-05-23 21:26:37.927 GMT [1] LOG: skipping missing configuration file “/var/lib/postgresql/data/postgresql.override.conf”
2025-05-23 21:26:37.927 UTC [1] FATAL: database files are incompatible with server
2025-05-23 21:26:37.927 UTC [1] DETAIL: The data directory was initialized by PostgreSQL version 14, which is not compatible with this version 16.8 (Debian 16.8-1.pgdg120+1).

dragonfire1119 · May 24, 2025, 2:43am

Looks like renovate updated to postgres 16 when I updated to 14, and the new one, Immich, requires.

Pull request for the fix:

github.com/bigbeartechworld/big-bear-casaos

Immich downgrade postgres image to 14

master ← update-postgres-image-to-14

opened 02:42AM - 24 May 25 UTC

dragonfire1119

+6 -2

- Downgraded the Postgres image used in the Immich application's Docker Compose …configuration from version 16 to version 14 to address compatibility issues. - Disabled Renovate updates for the `ghcr.io/immich-app/postgres` Docker image to prevent unintended updates to the Postgres version, which could potentially break the application.

kauelima · May 26, 2025, 1:21pm

In my case, I copied the tag 14-vectorchord0.3.0-pgvectors0.2.0 from the release notes and it worked!

dragonfire1119 · May 26, 2025, 5:39pm

You should of got the update from BigBearCasaOS. If you don’t then I would recommend you restart your CasaOS.