Run Redash Locally

This is only for educative purpose. You don’t have to do this in production

1 - Clone the project from the oficial github: Redash on GitHub - Y made a fork previously. Take Care

git clone https://github.com/geeklogbook/redash.git

2 - Modifiy the compose

version: "2"x-redash-service: &redash-service  image: redash/redash:8.0.0.b32245  depends_on:    - postgres    - redis  env_file: /opt/redash/env  restart: alwaysservices:  server:    <<: *redash-service    command: server    ports:      - "5000:5000"    environment:      REDASH_WEB_WORKERS: 4  scheduler:    <<: *redash-service    command: scheduler    environment:      QUEUES: "celery"      WORKERS_COUNT: 1  scheduled_worker:    <<: *redash-service    command: worker    environment:      QUEUES: "scheduled_queries,schemas"      WORKERS_COUNT: 1  adhoc_worker:    <<: *redash-service    command: worker    environment:      QUEUES: "queries"      WORKERS_COUNT: 2  redis:    image: redis:7-alpine    restart: unless-stopped  postgres:    image: pgautoupgrade/pgautoupgrade:15-alpine3.8    env_file: /opt/redash/env    volumes:      - /opt/redash/postgres-data:/var/lib/postgresql/data    restart: unless-stopped  nginx:    image: redash/nginx:latest    ports:      - "80:80"    depends_on:      - server    links:      - server:redash    restart: always

3 - Create the env in the opt/redash

REDASH_HOST=http://localhost/redashPYTHONUNBUFFERED=0REDASH_LOG_LEVEL=INFOREDASH_REDIS_URL=redis://redis:6379/0POSTGRES_PASSWORD=REDASH_COOKIE_SECRET=redash-selfhostedREDASH_SECRET_KEY=redash-selfhostedREDASH_DATABASE_URL=postgresql://postgres@postgres/postgresPOSTGRES_HOST_AUTH_METHOD=trust

4 - Run Docker

docker compose up

5 - Create database in server

docker-compose run --rm server create_db

6 - Create Test Database

docker-compose run --rm postgres psql -h postgres -U postgres -c "create database tests"

5 - The following url should show you the welcome page

# http://localhost:5000/

Sources:

• Setup self-hosted Redash Ready with Ubuntu Server (Local Machine/AWS)
• Unable to execute “server create_db” #6357
• [After upgrade to 5.0 (with docker-compose): failed to connect to server #2954](http://After upgrade to 5.0 (with docker-compose): failed to connect to server #2954)