Hướng Dẫn Backup Tự Động Database Supabase Miễn Phí Với GitHub Actions

1위@laptrinhfullstack4 giờ trước

name: Supabase Database Auto Backup on: schedule: # Runs at 00:00 UTC+7 (17:00 UTC) every day - cron: '0 17 * * *' workflow_dispatch: # Allows manual trigger from GitHub Actions tab jobs: backup: runs-on: ubuntu-latest steps: - name: Checkout code uses: actions/checkout@v4 - name: Install PostgreSQL 17 client run: | sudo apt-get update sudo apt-get install -y curl ca-certificates gnupg lsb-release curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list sudo apt-get update sudo apt-get install -y postgresql-client-17 - name: Run pg_dump Database Backup env: DB_URL: ${{ secrets.SUPABASE_DB_URL }} run: | TIMESTAMP=$(date +'%Y-%m-%d_%H-%M-%S') mkdir -p backups /usr/lib/postgresql/17/bin/pg_dump "$DB_URL" --no-owner --no-acl > backups/backup_${TIMESTAMP}.sql gzip backups/backup_${TIMESTAMP}.sql - name: Upload Backup Artifact to GitHub uses: actions/upload-artifact@v4 with: name: supabase-db-backup-${{ github.run_id }} path: backups/*.gz retention-days: 30번역 보기