Mattermost v8.0+ and PostgreSQL
-
@ericdrgn thanks. https://github.com/mattermost/docs/blob/master/source/deploy/postgres-migration.rst are the instructions it seems.
I am thinking of the below:
- pgLoader, morph and dbcmp tools can be preinstalled into the package.
- New installations will use postgres automatically
- Existing package will be converted to contain access to both a postgres and mysql database. Users have to follow the upstream docs to migrate.
Thoughts?
-
That's probably the best way to do it, if anyone doesn't necessarily care about the data in mattermost they can just archive the mysql version and spin up a new one that automatically uses postgres, otherwise the migration steps aren't crazy if maintaining the data is important.
-
@joestarrd not yet. Currently, the postgresql is going through some updates related to immich and discourse. We have to sort out the issues there before we attempt to move mattermost to postgres and test how compatible it is.
-
I checked their docs and the forum and afaict MySQL is not deprecated. I found nothing in their docs atleast. https://docs.mattermost.com/deploy/postgres-migration.html is quite complicated but it does say PostgreSQL is preferred. We have many users using Mattermost and it would be too much work to make them migrate, especially since it is still supported upstream. Do you know any timeline of deprecation? Upstream docs don't mention anything about deprecation from what I tried to find.
-
This is the original reference:
Basically the AI plugin will only be available on postgresql.
Furthermore, others plugins are dropping mysql support accordingly, ie:
I don't think anyone expects a smooth migration of their existing instance but it would great if we can get a supported postgresql package.
-