Automated tool to make periodic backups of PostgreSQL databases
Emmanuel Bouthenot
0b44a5e4e2
chore: Bump version to 2.5
|
5 hónapja | |
|---|---|---|
| examples | 10 hónapja | |
| services | 7 hónapja | |
| Changelog.md | 5 hónapja | |
| Documentation.md | 7 hónapja | |
| Makefile | 9 hónapja | |
| Readme.md | 7 hónapja | |
| autopostgresqlbackup | 5 hónapja |
Readme.md
AutoPostgreSQLBackup
AutoPostgreSQLBackup is a shell script (usually executed from a cron job) designed to provide a fully automated tool to make periodic backups of databases (supports PostgreSQL and MySQL/MariaDB).
AutoPostgreSQLBackup extract databases into flat files in a daily, weekly or monthly basis.
Version 2.2 adds support for MySQL/MariaDB.
Version 2.0 is a full rewrite.
It supports:
- Email notification
- Compression on the fly
- Encryption on the fly
- Rotation (daily and/or weekly and/or monthly)
- Databases exclusion
- Pre and Post scripts
- Local configuration
Usage
On Debian (or derived):
Install: apt install autopostgresqlbackup
That's it!
Documentation
See the documentation.
Manual page
Man page is build from the documentation using pandoc using the Makefile.
make man
History
- 2023: Almost full rewrite with better error handling and new features (see Changelog.md for details)
- 2019: Creation of a fork/standelone project on Github (https://github.com/k0lter/autopostgresqlbackup)
- Since 2011: Various patches (fixes and new features) were added in the Debian package
- 2011: AutoPostgreSQLBackup was included in Debian
- 2005: AutoPostgreSQLBackup was written by Aaron Axelsen (with some contributions of Friedrich Lobenstock)
- Project webpage was http://autopgsqlbackup.frozenpc.net/ (offline)
Authors
- Emmanuel Bouthenot (Current maintainer)
- Friedrich Lobenstock (Contributions)
- Aaron Axelsen (Original author)