Looking for a little bit of guidance regarding updating our temporal-server from 1.6.3 to the latest 1.9.2. It is my understanding the that schema updates are backwards compatible, so if I am reading the release notes properly, since we are already running 1.6.3, I should only need to update the schema to version 1.7.0 and then 1.9.0 (both of which have Schema changes), and then 1.9.2 should work just fine. Am I understanding that correctly?
We ensure that any consecutive versions are compatible in terms of database schema upgrades, features, and system behavior, however there is no guarantee that there is compatibility between any 2 non-consecutive versions.
However, the above from the documentation makes me think I am not correct? Or do I need to upgrade the schema AND version step by step?
Meaning, do I need to upgrade via Helm from 1.6.3 to 1.6.4 to 1.6.5 to 1.6.6, all the way up to 1.9.2, in order to guarantee all functionality? Do I need to run the postgres-upgrade tool with each version to support this as well, or just the versions I mentioned initially that contain schema changes?
Thanks for any pointers
EDIT: In my temporal database, I see schema_version shows 1.3, so I may need to make a stop at 1.5.0 as well since that includes schema changes?