Supabase Scheduled Database Backup #1

	name: Supabase Scheduled Database Backup

	on:
	schedule:
	# Run every Sunday at 02:00 UTC
	- cron: '0 2 * * 0'
	workflow_dispatch: # Allows manual trigger from GitHub UI

	jobs:
	backup:
	name: Database Dump Backup
	runs-on: ubuntu-latest
	steps:
	- name: Checkout Code
	uses: actions/checkout@v4

	- name: Install PostgreSQL Client
	run: \|
	sudo apt-get update
	sudo apt-get install -y postgresql-client

	- name: Run Database Dump
	env:
	DATABASE_URL: ${{ secrets.DATABASE_URL }}
	run: \|
	if [ -z "$DATABASE_URL" ]; then
	echo "DATABASE_URL secret is not defined. Skipping database dump."
	exit 0
	fi

	mkdir -p backups
	TIMESTAMP=$(date +"%Y%m%d_%H%M%S")
	BACKUP_FILE="backups/clientecho_backup_${TIMESTAMP}.sql"

	echo "Starting pg_dump..."
	pg_dump "$DATABASE_URL" --no-owner --no-acl -f "$BACKUP_FILE"
	gzip "$BACKUP_FILE"

	echo "Database backup completed: ${BACKUP_FILE}.gz"

	- name: Upload Backup Artifact
	uses: actions/upload-artifact@v4
	with:
	name: db-backup-${{ github.run_id }}
	path: backups/*.sql.gz
	retention-days: 30

Navigation Menu