Automated tool to make periodic backups of PostgreSQL databases

Emmanuel B 4c557a863b Merge pull request #4 from maxadamo/patch-1 11 months ago 9332e87048 Fix typos in README (bis) 3 years ago
autopostgresqlbackup a345facedf using "su -" instead of su 1 year ago


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.

AutoPostgreSQLBackup extract databases into flat files in a daily, weekly or monthly basis.

It supports:

  • Email notification
  • Compression
  • Encryption
  • Rotation
  • Databases exclusion
  • Pre and Post scripts
  • Local configuration


On Debian derived operating systems:

Install it : apt install autopostgresqlbackup

If the default options are not suitable for you, change them: $EDITOR /etc/default/autopostgresqlbackup

That's it!


  • 2005: AutoPostgreSQLBackup was written by AutoPostgreSQLBackup (with some contributions of Friedrich Lobenstock)
  • 2011: AutoPostgreSQLBackup was included in Debian
  • Since 2011: Various patches (fixes and new features) were added in the Debian package
  • 2019: Creation of a fork/standelone project on Github (


  • Aaron Axelsen (Original author)
  • Friedrich Lobenstock (Contributions)
  • Emmanuel Bouthenot (Current maintainer)