Recently we have planned to migrate Redash from version 8.0 to 9.0 for Beta testing. We have around 150 GB of data maintained as dashboards and important query results in our Postgres Database. While upgrading version we recently obtained following error stack :
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column dashboards.options does not exist LINE 2: ...rds_is_draft, dashboards.tags AS dashboards_tags, dashboards...
Please suggest possible solution for upgrading version while maintaining data consistency.
Thanks and Regards
- Redash Version: 9.0
- Browser/OS: Ubuntu 16.04.4 LTS
- How did you install Redash: Redash fork for version 9