Sync Production Database to Development
Run the database migration script to sync production data to local development environment.
Prerequisites
- Virtual environment must be activated:
source backend/env/bin/activate - AWS CLI configured with Parameter Store access
- Docker installed (for database operations)
Script Location
backend/scripts/migrate-prod-to-dev.sh
Usage Options
Download Production Database Only (Safest)
cd backend/scripts
./migrate-prod-to-dev.sh --download
Downloads production database to backend/backups/ without making any local changes.
Upload Latest Dump to Dev Database
cd backend/scripts
./migrate-prod-to-dev.sh --upload
Restores the most recent backup file to development database.
Run Django Migrations and Create Admin User Only
cd backend/scripts
./migrate-prod-to-dev.sh --setup
Runs migrations and creates/updates admin user (dev@genlayer.foundation / password).
Full Migration (Download + Upload + Setup)
cd backend/scripts
./migrate-prod-to-dev.sh
Complete workflow: download production data, restore to dev, run migrations, and create admin.
What It Does
- Fetches production database credentials from AWS Parameter Store
- Downloads production PostgreSQL database using Docker (matching version)
- Restores to development database (local or AWS dev instance)
- Runs Django migrations
- Creates/updates admin user with Steward role
Notes
- Backups are saved to
backend/backups/with timestamps - Uses Docker to avoid PostgreSQL version mismatch issues
- See
backend/scripts/README.mdfor detailed documentation and troubleshooting
Converted and distributed by TomeVault — claim your Tome and manage your conversions.