redash安装升级

1
2
3

curl -L "https://github.com/docker/compose/releases/download/1.29.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose

chmod +x /usr/local/bin/docker-compose

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

PYTHONUNBUFFERED=0
REDASH_LOG_LEVEL=INFO
REDASH_REDIS_URL=redis://redis:6379/0
POSTGRES_PASSWORD=123
REDASH_COOKIE_SECRET=456
REDASH_SECRET_KEY=789
REDASH_DATABASE_URL=postgresql://postgres:123@postgres/postgres
REDASH_MAIL_SERVER="1.1.1.1"
REDASH_MAIL_PORT=25
REDASH_MAIL_USE_TLS="false"
REDASH_MAIL_USE_SSL="false"
REDASH_MAIL_DEFAULT_SENDER="redash@soulchild.cn"

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

version: "2"
x-redash-service: &redash-service
  image: redash/redash:10.0.0.b50363
  depends_on:
    - postgres
    - redis
  env_file: /opt/redash/env
  restart: always
services:
  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:5.0-alpine
    restart: always
  postgres:
    image: postgres:9.6-alpine
    env_file: /opt/redash/env
    volumes:
      - /data/postgres-data:/var/lib/postgresql/data
    restart: always
  nginx:
    image: redash/nginx:latest
    ports:
      - "80:80"
    depends_on:
      - server
    links:
      - server:redash
    restart: always

1
2
3
4
5

# 初始化数据库(只有第一次启动需要执行)
docker-compose run --rm server create_db

# 启动redash相关组件
docker-compose up -d

1
2

docker-compose exec postgres pg_dump -Upostgres -d postgres  > /backup/redash-backup.sql
cp env /backup/env

1

docker-compose run --rm server manage db upgrade

1

docker-compose up -d