Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Mattermost
  3. Mattermost v8.0+ and PostgreSQL

Mattermost v8.0+ and PostgreSQL

Scheduled Pinned Locked Moved Mattermost
41 Posts 8 Posters 5.1k Views 9 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C Offline
      C Offline
      c0decafe
      wrote on last edited by
      #1

      The latest mattermost release now recommends PostgreSQL over MySQL and the project is generally planing to phase out support for MySQL.

      Any plans to migrate the cloudron mattermost app to PostgreSQL in the near future?

      Some new features such as AI bots are only available with PostgreSQL instances., and we would love to be able to leverage that as soon as possible.

      Just to plan accordingly, thanks!

      girishG 1 Reply Last reply
      0
      • girishG Do not disturb
        girishG Do not disturb
        girish
        Staff
        wrote on last edited by
        #2

        https://github.com/mattermost/mattermost/issues/18351 is tracking how to migrate.

        https://docs.mattermost.com/manage/bulk-export-tool.html and https://docs.mattermost.com/onboard/bulk-loading-data.html is possible the way to migrate but it says it doesn't migrate everything.

        1 Reply Last reply
        0
        • C c0decafe

          The latest mattermost release now recommends PostgreSQL over MySQL and the project is generally planing to phase out support for MySQL.

          Any plans to migrate the cloudron mattermost app to PostgreSQL in the near future?

          Some new features such as AI bots are only available with PostgreSQL instances., and we would love to be able to leverage that as soon as possible.

          Just to plan accordingly, thanks!

          girishG Do not disturb
          girishG Do not disturb
          girish
          Staff
          wrote on last edited by
          #3

          @c0decafe said in Mattermost v8.0+ and PostgreSQL:

          Any plans to migrate the cloudron mattermost app to PostgreSQL in the near future?

          yes, we will also move. Though the migration won't be automatic. I think we will just push a new package.

          C 1 Reply Last reply
          2
          • girishG girish

            @c0decafe said in Mattermost v8.0+ and PostgreSQL:

            Any plans to migrate the cloudron mattermost app to PostgreSQL in the near future?

            yes, we will also move. Though the migration won't be automatic. I think we will just push a new package.

            C Offline
            C Offline
            c0decafe
            wrote on last edited by
            #4

            @girish great, thank you. would be glad to help with testing or packaging.

            1 Reply Last reply
            0
            • M Offline
              M Offline
              mtd-sales
              wrote on last edited by
              #5

              I am running Cloudron for 10+ paying customers and counting. One of the reasons how I convince them to use Cloudron is the maintenance of their open source software. All of them use mostly Mattermost. Obviously I’m not too happy that you don’t offer a migration path and make us do the work manually.

              1 Reply Last reply
              0
              • girishG Do not disturb
                girishG Do not disturb
                girish
                Staff
                wrote on last edited by girish
                #6

                @mtd-sales you have to ask Mattermost team to provide a proper a migration path, this is not something we (cloudron team) can do. We just package the app.

                https://github.com/mattermost/mattermost/issues/18351 is the upstream issue.

                ericdrgnE 1 Reply Last reply
                1
                • M Offline
                  M Offline
                  mtd-sales
                  wrote on last edited by
                  #7

                  @girish I understand, thank you. Looks like they are working on a migration path. So I would prefer to wait before packaging a new one.

                  1 Reply Last reply
                  1
                  • ericdrgnE Offline
                    ericdrgnE Offline
                    ericdrgn
                    wrote on last edited by
                    #8

                    @girish Don't know if this helps at all but someone added a great guide on the upstream issue. https://github.com/mattermost/mattermost/issues/18351#issuecomment-1682072226

                    1 Reply Last reply
                    1
                    • girishG girish

                      @mtd-sales you have to ask Mattermost team to provide a proper a migration path, this is not something we (cloudron team) can do. We just package the app.

                      https://github.com/mattermost/mattermost/issues/18351 is the upstream issue.

                      ericdrgnE Offline
                      ericdrgnE Offline
                      ericdrgn
                      wrote on last edited by
                      #9

                      @girish looks like that issue https://github.com/mattermost/mattermost/issues/18351 is officially closed as the migration path is documented and successful at this point.

                      girishG 1 Reply Last reply
                      1
                      • ericdrgnE ericdrgn

                        @girish looks like that issue https://github.com/mattermost/mattermost/issues/18351 is officially closed as the migration path is documented and successful at this point.

                        girishG Do not disturb
                        girishG Do not disturb
                        girish
                        Staff
                        wrote on last edited by
                        #10

                        @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?

                        J 1 Reply Last reply
                        0
                        • ericdrgnE Offline
                          ericdrgnE Offline
                          ericdrgn
                          wrote on last edited by
                          #11

                          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.

                          1 Reply Last reply
                          0
                          • girishG girish

                            @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?

                            J Offline
                            J Offline
                            joestarrd
                            wrote on last edited by
                            #12

                            @girish said in Mattermost v8.0+ and PostgreSQL:

                            New installations will use postgres automatically

                            Was this implemented? We ran into the same problem but noticed new installations are still not using Postgres.

                            girishG 1 Reply Last reply
                            1
                            • J joestarrd

                              @girish said in Mattermost v8.0+ and PostgreSQL:

                              New installations will use postgres automatically

                              Was this implemented? We ran into the same problem but noticed new installations are still not using Postgres.

                              girishG Do not disturb
                              girishG Do not disturb
                              girish
                              Staff
                              wrote on last edited by
                              #13

                              @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.

                              J 1 Reply Last reply
                              0
                              • girishG girish

                                @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.

                                J Offline
                                J Offline
                                joestarrd
                                wrote on last edited by
                                #14

                                @girish understood, thank you for the quick update.

                                1 Reply Last reply
                                0
                                • C Offline
                                  C Offline
                                  cvachery
                                  wrote on last edited by
                                  #15

                                  Any update on this topic?
                                  I've had to stop a migration from a non-cloudron instance to cloudron because of this issue

                                  1 Reply Last reply
                                  0
                                  • girishG Do not disturb
                                    girishG Do not disturb
                                    girish
                                    Staff
                                    wrote on last edited by girish
                                    #16

                                    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.

                                    1 Reply Last reply
                                    0
                                    • C Offline
                                      C Offline
                                      c0decafe
                                      wrote on last edited by
                                      #17

                                      This is the original reference:

                                      • https://github.com/mattermost/mattermost-plugin-ai/issues/19#issuecomment-1609352822

                                      Basically the AI plugin will only be available on postgresql.

                                      Furthermore, others plugins are dropping mysql support accordingly, ie:

                                      • https://github.com/mattermost/mattermost-plugin-msteams/pull/482

                                      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.

                                      1 Reply Last reply
                                      2
                                      • C Offline
                                        C Offline
                                        cvachery
                                        wrote on last edited by
                                        #18

                                        Wouldn't it be possible to have an option passed to the Cloudron to let the user choose if he wants to use postgres or mysql?

                                        1 Reply Last reply
                                        1
                                        • girishG girish referenced this topic on
                                        • LanhildL Offline
                                          LanhildL Offline
                                          Lanhild
                                          App Dev
                                          wrote on last edited by
                                          #19

                                          @girish what about having a new Mattermost package, with the same name as the current one and shipping with postgresql.

                                          The current package (with MySQL) would have mysql somewhere in it's name, and then allow users to install whichever version they wish.

                                          Other than that, it looks like they are (or will be) abandoning MySQL support slowly

                                          image.png

                                          1 Reply Last reply
                                          0
                                          • chymianC Offline
                                            chymianC Offline
                                            chymian
                                            wrote on last edited by
                                            #20

                                            @girish the AI bot is getting more and more essential for daily work.
                                            any chance we get a postgresql version as supposed from @Lanhild for a fresh install?

                                            @girish said in Mattermost v8.0+ and PostgreSQL:
                                            New installations will use postgres automatically

                                            which is not the case till 9.7.4

                                            1 Reply Last reply
                                            0
                                            Reply
                                            • Reply as topic
                                            Log in to reply
                                            • Oldest to Newest
                                            • Newest to Oldest
                                            • Most Votes


                                              • Login

                                              • Don't have an account? Register

                                              • Login or register to search.
                                              • First post
                                                Last post
                                              0
                                              • Categories
                                              • Recent
                                              • Tags
                                              • Popular
                                              • Bookmarks
                                              • Search