Shell script for backing up PostgreSQL databases Clone to desired directory Modify pg_backup.config to your needs Add pg_backup.sh to crontab Execute crontab -e Append @daily /path/to/pg_backup.sh > /dev/null If you want something less heavy If you don't want to use AWS backups, try this If you want to do just one backup, try this