mattermost-docker icon indicating copy to clipboard operation
mattermost-docker copied to clipboard

Published 20 hours ago • verified publisher icon mattermost

the switch to postgres10 doesn't handle DB upgrades

Open hardaker opened this issue 3 years ago • 2 comments

The latest change to switch from postgres 9.4 to 10 doesn't upgrade the database and containers won't succeed because of the version incompatibility with the database files. (new installs likely work)

hardaker avatar Jun 18 '21 18:06 hardaker

there is everything about it inside the readme file, including an upgrade script. It seems it is currently not possible to upgrade the database automatically

btxtiger avatar Jun 21 '21 18:06 btxtiger

The script in the readme actually upgrades the existing database. I migrated our instance yesterday and used a rather "simple" approach to upgrade from the same thread.

https://github.com/mattermost/mattermost-docker/issues/489#issuecomment-845363495

The summary is:

  • backup current db
  • update dockerfiles (app + db)
  • clear database
  • import backup

Thats it.

In addition to @btxtiger 's comment i think we should accept that it is a breaking change and just add a dedicated "official" upgrade documentation.

oguera avatar Jun 23 '21 10:06 oguera