Skip to content

miniflux: 'postgres' database requires upgrade of collation version

While installing miniflux (on a machine upgraded from Bookworm) I saw the following error:

WARNING: database "postgres" has a collation version mismatch DETAIL: The database was created using collation version 2.36, but the operating system provides version 2.41. HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version. ERROR: template databa se "template1" has a collation version mismatch DETAIL: The template database was created using collation version 2.36, but the operating system provides version 2.41. HINT: Rebuild all obje cts in the template database that use the default collation and run ALTER DATABASE template1 REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.

Ultimately, I had to run "ALTER DATABASE postgres REFRESH COLLATION VERSION; ALTER DATABASE template1 REFRESH COLLATION VERSION;" to get the app to install and work properly.