Migrating from MariaDB to PostgreSQL DB

agriesser · October 7, 2022, 4:51am

Hi Gunter,

this approach might also be interesting for you:

github.com/mattermost/mattermost-server

Provide an official upgrade path from MySQL to PostgreSQL

opened 07:45PM - 07 Sep 21 UTC

mattermod

Up For Grabs Help Wanted

Original report: https://github.com/mattermost/mattermost-server/issues/15531 … **Summary** PostgreSQL is the preferred database for Mattermost, and there should be a supported upgrade path to it. **Possible fixes** As per related issue [#4911](https://github.com/mattermost/mattermost-server/issues/4911], pgloader seems to be the tool of choice for migrating to PostgreSQL. It would be great if the Mattermost team could provide [a load command file|https://pgloader.readthedocs.io/en/latest/tutorial/tutorial.html#id13) for it. This would enable the admin to create a new install (of the same version) so that so the schema can be known correct, then the tool need only migrate the data across. ---- If you're interested please comment here and come [join our "Contributors" community channel](https://community.mattermost.com/core/channels/tickets) on our daily build server, where you can discuss questions with community members and the Mattermost core team. For technical advice or questions, please [join our "Developers" community channel](https://community.mattermost.com/core/channels/developers). New contributors please see our [Developer's Guide](https://developers.mattermost.com/contribute/getting-started/). JIRA: https://mattermost.atlassian.net/browse/MM-28890

Topic		Replies	Views
Migration from MySQL 8 to Postgres Database Troubleshooting	22	5367	February 8, 2024
Migration from MySQL to Postgres fails Troubleshooting	9	3997	February 18, 2025
Error in Mattermost Boards after Upgrade to 7.5.1 Troubleshooting	8	2319	February 1, 2023
Migrating Mattermost Database from MySQL to PostgreSQL (using pgloader) Upgrade	2	125	October 30, 2025
After migrating from MySQL to PostgreSQL - too many SQL errors and features not working Upgrade	11	102	October 30, 2025

Migrating from MariaDB to PostgreSQL DB

Related topics