Database Backup Command Line Utility
Project description
Introduction
A logical database backup tool.
Create full binary backups of a PostgreSQL database
Restore a text or binary backup of a PostgreSQL database
Can restore a database over the top of an existing database (clears all data first) meaning you don’t need a super user to restore a database.
Usage
Create a backup with the contents going to a file
$ worek backup -d database_name -f ./backup.bin
Create a backup with the contents going to STDOUT
$ worek backup -d database_name \
| openssl enc -aes-256-cbc -pass file:password.txt -md sha256 -d -out backup.bak.enc
Restore a backup from STDIN. Note you have to use the -F property to specify the type of backup you are handing. This is not required when using -f and specifying the file path.
$ openssl enc -aes-256-cbc -pass file:password.txt -md sha256 -d -in backup.bak.enc \
| worek restore -h localhost -d database_name -F c
Supports standard PG environment variables
$ PGPORT=5432 worek backup -d database_name -f ./backup.bin
Changelog
0.1.0 released 2019-04-03
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for worek-0.1.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7b8265576b794caa6bdb318d13cb275a38918da80beb8f0db0effb48280199f6 |
|
MD5 | 19fb9bfbeeaf5542db27163d846afb7e |
|
BLAKE2b-256 | 99746bf442a5be850851e7b2d05bc7ef43c21ef650cc9ade94a43bd904eb6ba9 |