自建 RSS 服务迁移至 Miniflux

version: '3.4'
services:
  miniflux:
    image: miniflux/miniflux:latest
    container_name: miniflux_rss_server
    restart: always
    ports:
      - "183:8080"
    depends_on:
      - db
    environment:
      - DATABASE_URL=postgres://miniflux:password@db/miniflux?sslmode=disable
      - RUN_MIGRATIONS=1
      - CREATE_ADMIN=1
      - ADMIN_USERNAME=admin
      - ADMIN_PASSWORD=password
      - BASE_URL=https://rss2.bolitao.xyz
      - CLEANUP_ARCHIVE_UNREAD_DAYS=-1
      - CLEANUP_ARCHIVE_READ_DAYS=200
      - POLLING_FREQUENCY=20
    healthcheck:
      test: ["CMD", "/usr/bin/miniflux", "-healthcheck", "auto"]
  db:
    image: postgres:15
    container_name: miniflux_db_postgres
    environment:
      - POSTGRES_USER=miniflux
      - POSTGRES_PASSWORD=password
    volumes:
      - miniflux-db:/var/lib/postgresql/data
    healthcheck:
      test: ["CMD", "pg_isready", "-U", "miniflux"]
      interval: 10s
      start_period: 30s
volumes:
  miniflux-db:

vim /etc/nginx/sites-enabled/miniflux.conf

server {
  server_name rss2.bolitao.xyz;

  client_max_body_size        128M;

  location / {
    proxy_pass http://127.0.0.1:183;
    proxy_set_header    Host                $http_host;
    proxy_set_header    X-Real-IP           $remote_addr;
    proxy_set_header    X-Forwarded-For     $proxy_add_x_forwarded_for;
    proxy_set_header  X-Forwarded-Ssl     on;
    proxy_set_header  X-Forwarded-Proto   $scheme;
    proxy_set_header  X-Frame-Options     SAMEORIGIN;
    
    client_max_body_size        128M;
    client_body_buffer_size     128k;

    proxy_buffer_size           4k;
    proxy_buffers               4 32k;
    proxy_busy_buffers_size     64k;
    proxy_temp_file_write_size  64k;
  }
}

nginx -t
# output:
nginx: the configuration file /etc/nginx/nginx.conf syntax is ok
nginx: configuration file /etc/nginx/nginx.conf test is successful

nginx -s reload

certbot
# output:
Saving debug log to /var/log/letsencrypt/letsencrypt.log

Which names would you like to activate HTTPS for?
We recommend selecting either all domains, or all domains in a VirtualHost/server block.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
1: docker.bolitao.xyz
2: pw.bolitao.xyz
3: rss.bolitao.xyz
4: rss2.bolitao.xyz
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Select the appropriate numbers separated by commas and/or spaces, or leave input
blank to select all options shown (Enter 'c' to cancel): 4

vim /root/scripts/miniflux_backup.sh

#!/bin/bash

SCRIPT_DIR="/root"
NOW=$(date +"%Y%m%d")
TMP_PATH='/tmp'
DOCKER_NAME='miniflux_db_postgres'
MINIFLUX_DB="$TMP_PATH/miniflux_db.sql"
BAK_FILE_NAME="miniflux_db-$NOW.tar.gz"
BAK_FILE="$TMP_PATH/$BAK_FILE_NAME"
DROPBOX_DIR="/root/dropbox"

docker exec "$DOCKER_NAME" pg_dumpall -c -U miniflux > "$MINIFLUX_DB"
echo "数据库 SQL 导出完毕，正在打包压缩..."
tar cfzP "$BAK_FILE" "$MINIFLUX_DB"
echo "打包完成，准备上传..."
"$SCRIPT_DIR"/dropbox_uploader.sh upload "$BAK_FILE" "$DROPBOX_DIR/$BAK_FILE_NAME"
if [ $? -eq 0 ];then
     echo "上传完成"
else
     echo "上传失败"
fi
rm -f "$MINIFLUX_DB" "$BAK_FILE"

chmod +x /root/scripts/miniflux_backup.sh && bash /root/scripts/miniflux_backup.sh

数据库 SQL 导出完毕，正在打包压缩...
打包完成，准备上传...
 > Uploading "/tmp/miniflux_db-20230111.tar.gz" to "/root/dropbox/miniflux_db-20230111.tar.gz"... DONE
上传完成

crontab -e

0 3 * * 0 /bin/bash /root/scripts/miniflux_backup.sh > /dev/null