Skip to content

Instantly share code, notes, and snippets.

@PiAir
Created June 7, 2020 19:37
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save PiAir/2394dc611d138cc4dc015f3d98fbfdad to your computer and use it in GitHub Desktop.
Save PiAir/2394dc611d138cc4dc015f3d98fbfdad to your computer and use it in GitHub Desktop.
Redash docker install Synology
PYTHONUNBUFFERED=0
REDASH_LOG_LEVEL=INFO
REDASH_REDIS_URL=redis://redis:6379/0
# generate a password at https://www.pwdgen.org/
# use a different one for each of the next 3 lines
POSTGRES_PASSWORD=xxxxxx
REDASH_COOKIE_SECRET=-yyyyyy
REDASH_SECRET_KEY=-zzzzz
# replace the xxxxxx with the password generated for line 6
REDASH_DATABASE_URL=postgresql://postgres:xxxxxx@postgres/postgres
# create this file in a folder
# in my case in /volume1/docker/redash
# also create /volume1/docker/redash/postgres-data
version: '2'
x-redash-service: &redash-service
# check https://github.com/getredash/redash/releases for new versions and image tags
image: redash/redash:8.0.0.b32245
depends_on:
- postgres
- redis
# the .env file is located at this location on my Synology
# change if needed and see second env_file reference further below
env_file: /volume1/docker/redash/.env
restart: always
# you'l need to create this folder to be able to use the volume
# it enabled me to refence the /data folder from within redash as source for sqlite db
volumes:
- /volume1/docker/redash/data:/data
services:
server:
<<: *redash-service
command: server
# port 5000 was already in use on my Synology
ports:
- "5010: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:5.0-alpine
restart: always
postgres:
image: postgres:9.5-alpine
# change to correct location
env_file: /volume1/docker/redash/.env
volumes:
- /volume1/docker/redash/postgres-data:/var/lib/postgresql/data
restart: always
nginx:
image: redash/nginx:latest
ports:
- "8090:80"
depends_on:
- server
links:
- server:redash
restart: always
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment