the switch to postgres10 doesn't handle DB upgrades
hardaker opened this issue · 2 comments
hardaker commented
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
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
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.
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.