RDS Digital Database Backup

Mediocre Developer

RDS Digital Database Backup

Backing up and restoring the digital database from AWS RDS instance

ssh -i ~/.ssh/adid_ed25519 admin@integration.xxxxx.tv

pg_dump -h xxxxx.amazonaws.com -U postgres -d digital > prod.digital.backup.sql

integrationScp prod.digital.backup.sql

psql -U postgres -p 5432 -d digital -f prod.digital.backup.sql