从Neon拉取到本地#

1. 使用本地的postgres从neon dump

1
sudo docker compose exec -T memos-postgres pg_dump "You_PG_URL" > ./backup/memos_backup.sql

2. 恢复到本地postgres数据库

1
cat ./backup/memos_backup.sql | sudo docker compose exec -T memos-postgres psql -U memos -d memos

备份到云端#

1. 创建脚本 sync_to_cloud_backup.sh

   1
   #!/bin/bash
   2
   set -euo pipefail
   3
   
   4
   # === Configuration ===
   5
   
   6
   # 1. Your Compose project network's full name
   7
   # Verify with: sudo docker network ls | grep caddy_network
   8
   COMPOSE_NETWORK="docker_caddy_network"
   9
   
   10
   # 2. Backup path (using your home directory for safety)
   11
   BACKUP_DIR="/home/yukki/docker/backup"
   12
   mkdir -p "$BACKUP_DIR"
   13
   DUMP_FILE="$BACKUP_DIR/redis.dump" # Define the dump file name
   14
   
   15
   # 3. PostgreSQL (Neon connection string)
   16
   NEON_DB_URL="You_PG_URL"
   17
   
   18
   # 4. Redis (Upstash connection string)
   19
   UPSTASH_URL="You_Upstash_URL"
   20
   
   21
   # 5. Log file
   22
   LOG_FILE="$BACKUP_DIR/backup_$(date +%Y%m%d_%H%M%S).log"
   23
   exec > >(tee -a "$LOG_FILE") 2>&1
   24
   
   25
   echo "===== Backup started at $(date) ====="
   26
   
   27
   # === PostgreSQL Part (Memos Backup) ===
   28
   # ... (This part was correct, keep it) ...
   29
   echo "[1/2] Dumping PostgreSQL from 'memos-postgres'..."
   30
   docker compose exec -T memos-postgres \
   31
       pg_dump -U memos -d memos --format=custom \
   32
       > "$BACKUP_DIR/memos.dump"
   33
   
   34
   echo "[1/2] Restoring PostgreSQL dump to Neon..."
   35
   docker run --rm -v "$BACKUP_DIR/memos.dump:/backup/memos.dump" postgres:17 \
   36
       pg_restore --clean --no-acl --no-owner -d "$NEON_DB_URL" /backup/memos.dump
   37
   
   38
   echo "✅ PostgreSQL (Memos) backup to Neon successful."
   39
   
   40
   # === Redis Part (LunaTV Backup) ===
   41
   
   42
   # !!! Using the Go binary to DUMP and redis-cli to PIPE from file !!!
   43
   echo "[2/2] Dumping Redis from 'lunatv-redis' (using Go tool)..."
   44
   
   45
   # !!! Prerequisite: Ensure lunatv-redis exposes port 6379 to host's localhost:
   46
   # ports:
   47
   #  - "127.0.0.1:6379:6379"
   48
   # (Restart lunatv-redis if you just added this)
   49
   
   50
   # Execute the Go binary to dump to the file
   51
   # Using the correct flags based on its help output
   52
   ./backup/upstash-redis-dump \
   53
       -host localhost \
   54
       -port 6379 \
   55
       --output resp \
   56
       > "$DUMP_FILE"
   57
   
   58
   echo "[2/2] Piping Redis dump file to Upstash (using redis-cli)..."
   59
   
   60
   # Execute redis-cli inside the lunatv-redis container
   61
   # Use --tls and --pipe, reading (<) from the dump file
   62
   # Note: We mount the backup dir into the container temporarily
   63
   docker run --rm \
   64
       --network="$COMPOSE_NETWORK" \
   65
       -v "$BACKUP_DIR:/backup" \
   66
       redis:alpine \
   67
       sh -c "redis-cli --tls -u '$UPSTASH_URL' --pipe < /backup/redis.dump"
   68
   
   69
   echo "✅ Redis (LunaTV) backup to Upstash successful."
   70
   
   71
   # Cleanup the temporary dump file (optional)
   72
   # rm -f "$DUMP_FILE"
   73
   
   74
   echo "===== Backup finished successfully at $(date) ====="
   

2. 下载upstash-redis-dump到backup目录 https://github.com/upstash/upstash-redis-dump

3. 给予执行权限

   1
   chmod +x /home/yukki/docker/sync_to_cloud_backup.sh
   2
   chmod +x /home/yukki/docker/backup/upstash-redis-dump
   

4. 执行脚本

   1
   sudo /home/yukki/docker/sync_to_cloud_backup.sh
   

5. 定时备份

   1
   sudo crontab -e
   2
   # 每天凌晨 3:00 执行备份脚本
   3
   0 3 * * * /usr/bin/bash /home/yukki/docker/sync_to_cloud_backup.sh >> /home/yukki/docker/backup/cron_$(date +\%Y\%m\%d).log 2>&1