DEV Community

Discussion on: Backup Postgres to S3

Collapse
maxborysov profile image
Max Borysov • Edited

yeap, I do exactly the same :) Having a bash script with mysqldump and then upload to s3.

Collapse
iamkarshe profile image
Utkarsh Kumar Raut

Our Complete Automation Template

  1. Cron runs at every 12th hour. crontab
  2. Run script (mysqldump) to make backup
  3. Trigger script (php) to sync backup with Google Cloud Storage
  4. If all good all fine, we trigger another script (php) for Slack notification to our dev team