I’m using a legacy Redash V5 (Bitnami) and need to migrate it to a new instance with version 8 installed. The reason is providing the ability to connect to Presto using password! Based on my research, the only way to migrate dashboards and queries is to make a backup from Postgres and import it to the new instance. Unfortunately, I stuck in importing my backup and need help. Below are my performed steps:
- make a tar.gz backup using the postgres dump from the running instance. (Backup size is 3.8 GB) Using: pg_dump -U postgres -F c bitnami_redash > /newvolume/backup.tar.gz
- Installed a docker based Redash with the exact same version.
- Copy the backup file to my ubuntu server.
- Import the backup file using: cat backup.tar.gz | docker exec -i redash_postgres_1 pg_restore -Upostgres
As I said, the import process is taking so long without any proper result. I really appreciate any help to solve my problem or any other practical way to do the needful. Thanks!