1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
|
# 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](/Documentation.md).
## Manual page
Man page is build from [the documentation](/Documentation.md) 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)
|
