1
version: '3.8'
2

3
services:
4
  umami:
5
    image: ghcr.io/umami-software/umami:postgresql-latest
6
    container_name: umami
7
    ports:
8
      - "3000:3000"
9
    env_file:
10
      - .env
11
    environment:
12
      DATABASE_URL: postgresql://${POSTGRES_USER}:${POSTGRES_PASSWORD}@db:5432/${POSTGRES_DB}
13
      APP_SECRET: ${APP_SECRET}
14
    depends_on:
15
      db:
16
        condition: service_healthy
17
    restart: always
18
    logging:
19
      driver: "json-file"
20
      options:
21
        max-size: "10m"
22
        max-file: "3"
23

24
  db:
25
    image: postgres:15-alpine
26
    container_name: umami_db
27
    env_file:
28
      - .env
29
    volumes:
30
      - umami-db-data:/var/lib/postgresql/data
31
    restart: always
32
    healthcheck:
33
      test: ["CMD-SHELL", "pg_isready -U ${POSTGRES_USER}"]
34
      interval: 10s
35
      timeout: 5s
36
      retries: 5
37
    logging:
38
      driver: "json-file"
39
      options:
40
        max-size: "10m"
41
        max-file: "3"
42

43
volumes:
44
  umami-db-data:

1
POSTGRES_USER=umami
2
POSTGRES_PASSWORD=your_very_secure_password_here
3
POSTGRES_DB=umami
4
APP_SECRET=your_random_secret_string_here

1
docker compose up -d

1
[dotenv@17.2.1] injecting env (0) from .env -- tip: ? prevent committing .env to code: https://dotenvx.com/precommit ✓ DATABASE_URL is defined. ✗ Unable to connect to the database: Authentication failed against database server, the provided database credentials for umami are not valid. Please make sure to provide valid database credentials for the database server at the configured address.  ELIFECYCLE  Command failed with exit code 1. ERROR: "check-db" exited with 1.  ELIFECYCLE  Command failed with exit code 1.

1
docker exec -it umami_db psql -U umami -d umami

1
ALTER USER umami WITH PASSWORD 'your_very_secure_password_here';

1
#!/bin/bash
2

3
set -e  # 出错立即退出
4

5
# 配置
6
CONTAINER_NAME="umami_db"              # PostgreSQL 容器名
7
DB_USER="umami"                        # 数据库用户名（和 .env 一致）
8
DB_NAME="umami"                        # 数据库名（和 .env 一致）
9
LOCAL_BACKUP_DIR="/root/backups"       # 本地临时备份目录
10
BACKUP_FILENAME="umami_backup_latest.sql.gz"
11
RCLONE_REMOTE="jianguoyun:/umami_backup"
12

13
# 创建本地备份目录
14
mkdir -p "$LOCAL_BACKUP_DIR"
15

16
# 导出数据库并压缩
17
echo "? 正在备份数据库..."
18
docker exec -t "$CONTAINER_NAME" pg_dump -U "$DB_USER" "$DB_NAME" | gzip > "$LOCAL_BACKUP_DIR/$BACKUP_FILENAME"
19

20
# 确认备份生成
21
if [ ! -f "$LOCAL_BACKUP_DIR/$BACKUP_FILENAME" ]; then
22
    echo "❌ 备份失败，未生成文件"
23
    exit 1
24
fi
25

26
# 确保坚果云目录存在
27
rclone mkdir "$RCLONE_REMOTE"
28

29
# 上传前先清理坚果云旧备份
30
echo "? 正在清理坚果云旧备份..."
31
rclone delete "$RCLONE_REMOTE"
32

33
# 上传新备份
34
echo "☁️ 正在上传到坚果云..."
35
if rclone copy "$LOCAL_BACKUP_DIR/$BACKUP_FILENAME" "$RCLONE_REMOTE"; then
36
    echo "✅ 上传成功"
37
    rm "$LOCAL_BACKUP_DIR/$BACKUP_FILENAME"   # 上传成功后删除本地备份
38
else
39
    echo "❌ 上传失败"
40
    exit 1
41
fi
42

43
echo "? 最新备份已完成并上传（只保留最新）"

1
docker ps | grep umami_db

1
gunzip < /root/backups/umami_backup_latest.sql.gz | docker exec -i umami_db psql -U umami -d umami

1
docker exec -it umami_db psql -U umami -d umami -c "SELECT * FROM event LIMIT 5;"