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?
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?
