Database collation mismatch
❓Question☑️Ready
I have just updated to immich 2.6.1 and initially it failed due to the fact I was still running postgres 15. I tried migrating to postgres 18 which initially failed but after following these steps I got the app to start.
https://www.reddit.com/r/immich/comments/1ryxi72/immich_truenas_update_immich_database_from/
immich now runs fine and has successfully completed a database dump using pg18, but I am now getting these error logs:
Is this something I need to fix or will it sort itself out?
I am running immich on TrueNAS 25.04.2.6 using the community app Version: v1.14.2.
https://www.reddit.com/r/immich/comments/1ryxi72/immich_truenas_update_immich_database_from/
immich now runs fine and has successfully completed a database dump using pg18, but I am now getting these error logs:
Is this something I need to fix or will it sort itself out?
I am running immich on TrueNAS 25.04.2.6 using the community app Version: v1.14.2.
r/immich
Reddit
If you face the issue to upgrade to postgres 18, you can use the following steps to update your Immich database from Postgres…
