Installed the redash version 5.0.2.b5486 on Ubuntu back in Nov-2018. Created few dashboards. Things are working fine. I am trying to copy the setup (dashboards/data sources etc) to a new box. Not able to figure out how to take the backup though.
Tried to backup:
# Uncompressed backup $ sudo -u redash pg_dump > backup_filename.sql # redash user not found
I tried to see if postgres is running
$ psql # not able to connect to db # no postgres file in /var/run
Then I realized redash is dockerized.
$ sudo docker ps # shows 7 containers running $ sudo docker exec -it redash_postgres_1 bash bash-4.3# psql -U postgres postgres=# \l # this does not show redash database
Tried few other options:
$ sudo docker exec -t redash_server_1 pg_dump > ~/backup_filename.sql $ sudo docker exec -t redash_postgres_1 pg_dump > ~/backup_filename.sql
Not sure what am I doing wrong.
- Redash Version: 5.0.2.b5486
- Browser/OS: Ubuntu 18.04.1 LTS
- How did you install Redash: as per the documentation ($ git clone https://github.com/getredash/redash.git; cd redash; bash setup/setup.sh;)