Autopostgresqlbackup – Backup your PostgreSQL databases daily,weekly, and monthly
Autopostgresqlbackup is a shell script (usually executed from a cron job) designed to provide a fully automated tool to make periodic backups of PostgreSQL databases.
On Debian systems, autopostgresqlbackup can be configured by editing some options in file /etc/default/autopostresqlbackup
Install Autopostgresqlbackup on ubuntu
Open the terminal and run the following command
sudo apt-get install autopostgresqlbackup
The above command will complete the installation process
You need to run the following command to run the backup
you have the backups in /var/lib/autopostgresqlbackup organized by daily/weekly/monthly folders then databasename folder.
If you need to configure parameters such as host, restricted databases to backup, compression type, etc…, autopostgresqlbackup file in /etc/default/ is what you are looking for
sudo vi /etc/default/autopostgresqlbackup
Ubuntu installs a cron script with this program that will run it every day. It will organize the files to the appropriate directory.