#!/bin/bash
# Database credentials
 user=""
 password=""
 db_name=""

# Other options
 backup_path="/home/ec2-user/backup"
 date=$(date +"%d-%b-%Y")

# Dump database into SQL file
 PGPASSWORD="$password" pg_dump -U $user $db_name > $backup_path/$db_name-$date.sql

# zip dump
 zip $backup_path/$db_name-$date.zip $backup_path/$db_name-$date.sql

# remove raw file
 rm $backup_path/$db_name-$date.sql

# Delete files older than 30 days
 find $backup_path/* -mtime +30 -exec rm {} \;