DEV Community

Discussion on: Backup Postgres to S3

maxborysov profile image
Max Borysov • Edited

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

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