the switch to postgres10 doesn't handle DB upgrades

hardaker commented 3 years ago

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)

btxtiger commented 3 years ago

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

oguera commented 3 years ago

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.

mattermost / mattermost-docker

the switch to postgres10 doesn't handle DB upgrades #540