1

I want to upgrade to V8 from v5. Help me with any link to do so. I came across quite few link. some say first upgrade to v7 & then to v8, but i am not able to find copy of v7. Please support. Thanks & Cheers

2

Hi there :wave: How did you install your current instance of Redash? I found some links in the documentation that cover how to upgrade for both docker and non-docker versions. Those would be a good place to start. It’s not difficult to upgrade the version but technical background is a big plus.

3

Hi @k4s1m I install redash using docker

4

I have taken backup of postgres_sql and all queries. Is there anything left before updating the redash?

5

Nope that’s all! Then you can just follow the instructions in the documentation:

Upgrade Process

  1. Make sure to backup your data. You only need to backup Redash’s PostgreSQL database (the database Redash stores metadata in, not the ones you might be querying) as the data in Redis is transient.
  2. Change directory to /opt/redash .
  3. Update /opt/redash/docker-compose.yml Redash image reference to the one you want to upgrade to.
  4. Stop Redash services: docker-compose stop server scheduler scheduled_worker adhoc_worker (you might need to list additional services if you updated your configuration)
  5. Apply migration (if necessary): docker-compose run --rm server manage db upgrade
  6. Start services: docker-compose up -d

Done!

6

Thanks , but i stuck on third step i.e to update redash image . I read some of the reviews they suggest to do not upgrade directly to version 8.0 from 5.0.
And also i could not found version 7.0
Can yo tell me how can i update it or found specific version?

7

On the documentation page there is a table that lists the names of the images. For version 7 it shows redash/redash:7.0.0.b18042. Have you tried this?

8

No , I didn’t. how to update to that image ? Is there any command for that?

9

That’s part of step 3. You write the new image name in docker-compose.yml.

10

So i have to change the name in docker-compose.yml and then move to step 4. right?

11

Yes that’s it. And once you’re in 7 repeat all steps for the version 8.

12

okay, Thanks. I will do that

13

don’t forget to look for each version if particular steps are needed !

15

Thank you all for your valuable response. I have upgrade it successfully

2 Likes
16

Hi k4s1m,

Can you provide the backup and restore postgreSQL command or process?

When I backup redash 5.0.2 data and restore it to redash 8.0.0 , the data source was not working.

I have no idea how to debug, any hint?

BTW, the following was my command and procedures.

  1. backup the postgreSQL from 5.0.2
    cid=docker ps | grep postgres | awk '{print $1}'
    docker exec {cid} /bin/bash -c 'pg_dump -U postgres postgres | gzip > /usr/local/redash_backup.gz' docker cp {cid}:/usr/local/redash_backup.gz redash_backup.gz

  2. Copy the backup file to redash 8.0.0

  3. After I successfully docker-compose up -d

  4. docker-compose stop server scheduler scheduled_worker adhoc_worker

  5. restore the data from the backup file
    cid=docker ps | grep postgres | awk '{print $1}'
    docker cp redash_backup.gz {cid}:/usr/local/redash_backup.gz docker exec -it {cid} /bin/bash
    psql -U postgres template1
    DROP DATABASE IF EXISTS postgres;
    CREATE DATABASE postgres;
    \q
    zcat /usr/local/redash_backup.gz | psql -U postgres -d postgres
    exit

cd /opt/redash
docker-compose run --rm server manage db upgrade
docker-compose up -d

It works in the same version of redash, but not work in 8.0.0

REF: https://medium.com/marsw-redash/redash-備份-還原-升級-cc9f856cfd7b