Migration guidelines from MySQL to PostgreSQL#

plans-img Available on all plans

deployment-img self-hosted deployments

From Mattermost v8.0, PostgreSQL is our database of choice for Mattermost to enhance the platform’s performance and capabilities. Recognizing the importance of supporting the community members who are interested in migrating from a MySQL database, we have taken proactive measures to provide guidance and best practices.

  • Automated migration from MySQL to PostgreSQL - A comprehensive set of guidelines and a migration-assist tool to streamline the migration process, alleviate potential challenges, and faciliate a smooth transition.

  • Manually migrate from MySQL to PostgreSQL - A good option if your organization has database administrators to own the migration process, or if you want to learn what the migration-assist tool automates for you.