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
Database Migration MariaDB to PostgreSQL Troubleshooting	2	682	October 18, 2022
Change installation from Debian package to Omnibus Troubleshooting	1	195	May 12, 2023
Self-hosted MySQL to PostgreSQL migration	0	480	August 3, 2023
Migrating PostgreSQL to MySQL Troubleshooting	1	3343	July 1, 2017
Migration from MySQL 8 to Postgres Database Troubleshooting	22	1385	February 8, 2024

Migrating from MariaDB to PostgreSQL DB

Related Topics