Automated PostgreSQL database Backup on Linux.
-
pg_backup.config
- The main configuration file. This should be the only file which needs user modifications.
-
pg_backup.sh
- The normal backup script which will go through each database and save a gzipped and/or a custom format copy of the backup into a date-based directory.
-
pg_backup_rotated.sh
- The same as above except it will delete expired backups based on the configuration.
-
- Simple crontab job that runs the backup script at 00:00 on every day-of-week from Sunday through Friday.
-
- Simple pg_dump db, needs manual config
Files 1, 2 and 3 copied from https://wiki.postgresql.org/wiki/Automated_Backup_on_Linux