Suhail Ghafoor Phoenix-Effect
powellc
/ pg_backup_all.sh
Last active
October 28, 2024 06:22
Bash script to backup all postgresql databases on a server, run with cron once a day or 5 times a day, whatever. Just updated it so it ignores your postgres db, and also bzips the backups and adds a symlink to a latest directory. Sweet.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # Location to place backups. | |
| backup_dir="/var/backups/databases/" | |
| nightly_dir="/var/backups/databases/latest/" | |
| #String to append to the name of the backup files | |
| backup_date=`date +%d-%m-%Y` | |
| #Numbers of days you want to keep copie of your databases | |
| number_of_days=15 | |
| databases=`psql -l -t | cut -d'|' -f1 | sed -e 's/ //g' -e '/^$/d'` | |
| for i in $databases; do if [ "$i" != "postgres" ] && [ "$i" != "template0" ] && [ "$i" != "template1" ] && [ "$i" != "template_postgis" ]; then |