experiment generating multiple login users for pgbouncer #23
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Ferry DB Snapshot | |
| on: | |
| push: | |
| branches: [main] | |
| paths: | |
| - "db/**" | |
| - ".github/workflows/ferry_db_snapshot.yml" | |
| schedule: | |
| - cron: "0 0 * * 1" # Every Monday | |
| workflow_dispatch: | |
| jobs: | |
| backup: | |
| runs-on: self-hosted | |
| steps: | |
| - name: Dump Ferry DB | |
| run: | | |
| docker exec db pg_dump -U postgres -x ferry > "/home/app/ferry_snapshots/$(date +%F).sql" | |
| - name: Upload to R2 | |
| run: | | |
| rclone copy "/home/app/ferry_snapshots/$(date +%F).sql" r2:ferry-backup/ | |
| - name: Create R2 Signed URL | |
| run: | | |
| rclone link "r2:ferry-backup/$(date +%F).sql" | grep -o 'https://[^"]*' > output.txt | |
| - name: Update Doppler Secret | |
| run: | | |
| doppler setup -p coursetable -c dev | |
| doppler secrets set FERRY_DUMP_URL="$(cat output.txt)" > /dev/null | |
| - name: Delete Old Snapshots | |
| run: | | |
| find /home/app/ferry_snapshots -type f -mtime +30 -delete |