Backups and recovery

​

Backup strategy

​

Manual backups

# Create a backup
pg_dump $DATABASE_URL > backup_$(date +%Y%m%d).sql

# Restore from backup
psql $DATABASE_URL < backup_20260904.sql

​

Recovery procedures

​

Accidental data deletion

​

Migration failure

​

Full database corruption

1. Suspend the application (Render dashboard)
2. Create a branch from the latest clean backup
3. Verify the branch holds the expected data
4. Promote the branch
5. Update DATABASE_URL in Render if the endpoint changed
6. Resume the application and run smoke tests

​

Recovery time objectives

​

Verification checklist

​

What is not backed up