Immich DB Broken after update
I updated to the latest version of Immich, and my postgres db has broken. I had the image set as just postgres, so I think it must have updated and broke it. I tried to change the version to postgres:15, but then I get the error:
The database was created using collation version 2.31, but the operating system provides version 2.36.
2023-09-21 17:11:38.126 AMERICADENVER [53] HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE immich REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
What is the best way to fix this?
6 Replies
This is why you should always use a specific image tag. The error is indicating that your postgres data is mismatched with the version of the image. Maybe try
:14?Then it gives this error: The data directory was initialized by PostgreSQL version 15, which is not compatible with this version 14.9 (Debian 14.9-1.pgdg120+1).
Seems like this might be what is happening https://github.com/docker-library/postgres/issues/1099
GitHub
Docker image for version 15.3 throws collation warnings · Issue #10...
Since today we see the following warnings in our application logs: [WARN ] 2023-06-15 10:58:36 [ main][o.h.e.j.spi.SqlExceptionHelper]: SQL Warning Code: 0, SQLState: 01000 [WARN ] 2023-06-15 10:58...
So do you know what the best way to fix it would be?
Try the suggestions in that thread?
I didn’t see anything talking about how to fix it
Ok.. changing it to postgres:15-bullseye fixed the problem