Skip to content

database-backups.md

Latest commit

 

History

History
24 lines (18 loc) · 915 Bytes

database-backups.md

File metadata and controls

24 lines (18 loc) · 915 Bytes

PostgreSQL Database Backups

Azure Postgres automated backups

Backups are automated with daily snapshots and transaction logs allowing point-in-time restore.

Nightly backup

  • The Backup production database workflow runs nightly around 04:00 UTC
  • Take a full backup
  • Saves the full backup to Azure Storage account

Connect to the database

The konduit.sh script creates a tunnel connected to the database via the running application and allows using psql, pg_dump...

make bin/konduit.sh
make qa get-cluster-credentials
bin/konduit.sh teaching-vacancies-qa -- psql

For convenience when obtaining quick DB PSQL consoles, we have a script that maps to konduit internally:

bin/psql qa