Database changes for Redash upgrade

Issue Summary

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

Technical details:

  • Redash Version: 9.0
  • Browser/OS: Ubuntu 16.04.4 LTS
  • How did you install Redash: Redash fork for version 9

You can’t upgrade and migrate at the same time. Break it into separate steps:

  1. Clone your current V8 database into a new V8 instance
  2. Upgrade this new V8 instance to V9 and run the needed migrations

The error happens because V9 expects to see dashboards.options which isn’t part of the V8 data model.

Pardon me for not mentioning. Currently we have decoupled the database to a separate RDS Instance for V8. Now we wish to move to a newer version which is v9.0. Hence currently we were re-pointing the postgres connection string to the old schema model. Can you suggest work around for same?

Thanks for the added context.

Actually it makes no difference where your database is. The same idea applies.

  1. Clone your V8 database.
  2. Clone your V8 Redash and point it at the cloned database
  3. Upgrade the instance from step 2 from V8 → V9. This will automatically upgrade the schema from step 1 from V8 → V9.