search

YunoHost-Apps / mattermost_ynh

Mattermost package for YunoHost
http://www.mattermost.org
GNU General Public License v3.0
33 stars 19 forks source link

MariaDB to PostgreSQL migration script? #418

Closed ylluminate closed 9 months ago

ylluminate commented 1 year ago

I've been struggling for some time to migrate from Mattermost 6.4.1 on MariaDB to PostgreSQL. This has been a roadblock for further updates and has been discussed quite a bit elsewhere. Is the https://github.com/YunoHost-Apps/mattermost_ynh/blob/master/scripts/upgrade script a path forward to use directly to migrate an instance such as my Mattermost 6.4.1 on MariaDB over to PostgreSQL?

If so, do you have some methodology and instructions handy or is this a "read the script and do your best" scenario?

I have no problem reading the script and repeating what you've done, but I just want to be sure my proverbial horse is going north here and not some other direction...

kemenaran commented 1 year ago

Erf, I didn't have much to do with the writing of the script itself (I mostly did QA and improvements), but I don't think there's much more knowledge in this than "We fiddled with SQL statements until it worked"…

ylluminate commented 9 months ago

@ericgaspar I have continued to struggle with an older migration in this respect - specifically Mattermost 6.4.1. I have attempted manual and otherwise migrations, but nothing has worked thus far. Do you perceive more recent updates to your effort as having firmed this up even for older versions?

I have been unsure as to whether I should attempt to upgrade MariaDB or simply first cross-migrate to MySQL and then to PGSQL...