Installation:
pip install inipgdump
Creates a dump of the PostgreSQL database. The naming format of dump:
$host_$dbname_$datetime.dump
Stores the specified number of dumps, deletes the old dumps.
Options to create a dump taken from the configuration file in the following format:
[database] DATABASE_NAME = your_value DATABASE_USER = your_value DATABASE_PASSWORD = your_value DATABASE_HOST = your_value DATABASE_PORT = your value
Usage:
(without rotation): inipgdump config_file.ini /dump/dir (with rotation): inipgdump config_file.ini /dump/dir keep_count
Examples of usage in the cron:
::
# Daily backup 0 4 2-31 * 0-5 inipgdump /path/to/config_file.ini /dumps/daily 7 # Weekly backup 0 4 2-31 * 6 inipgdump /path/to/config_file.ini /dumps/weekly 8 # Monthly backup 0 4 1 2-12 * inipgdump /path/to/config_file.ini /dumps/monthly 12 # Yearly backup 0 4 1 1 * inipgdump /path/to/config_file.ini /dumps/yearly 10