Actually it's quite simple and something I encourage people to do when they go to "production" with their Redash instance.
It's trickier for existing setup, but for a new instance it's quite simple:
The steps are:
1. Create the RDS instance.
2. Create database and user for Redash.
/opt/redash/.env to point at the URL of the new RDS instance.
sudo -u redash bin/run ./manage.py database create_tables (create the tables).
5. Again from
sudo -u redahs bin/run ./manage.py users create --admin --password admin "Admin" "admin" (create admin user, better change the password to something which isn't
6. Restart everything (
supervisorctl restart all).
If you want to migrate an existing instance, then instead of steps 4-5 you need to:
- Create a backup of the existing database using
- Restore this backup into the RDS database.
There is a page in the docs on how to backup/restore the DB, it might help here.