PGBackup

Backup script written in Python to dump a postgres database and upload it to a FTP

Usage

usage: backup.py [-h] --db DB --ftp FTP [--pgdump PGDUMP] [--max MAX]
                 [--name NAME]

If an arg is specified in more than one place, then commandline values
override environment variables which override defaults.

optional arguments:
  -h, --help       show this help message and exit
  --db DB          database url (e.g. postgres://postgres@localhost/db) [env
                   var: DATABASE_URL]
  --ftp FTP        FTP url (e.g.
                   ftp://backup:password@backup.network/backups/mydb) [env
                   var: FTP_URL]
  --pgdump PGDUMP  pg_dump path command [env var: PG_DUMP_COMMAND]
  --max MAX        maximum count of backups [env var: MAX_FILES]
  --name NAME      backup name [env var: BACKUP_NAME]

A Docker image bdeinsalyon/pgbackup is also available

ToDo

• Implement Duplicity (http://duplicity.nongnu.org/) as backup storage

License

This script is given under MIT License.

© 2017, Philippe VIENNE