Skip to main content

Database Backup Command Line Utility

Project description


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.


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


0.1.0 released 2019-04-03

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for worek, version 0.1.0
Filename, size File type Python version Upload date Hashes
Filename, size worek-0.1.0-py2.py3-none-any.whl (15.4 kB) File type Wheel Python version py2.py3 Upload date Hashes View
Filename, size worek-0.1.0.tar.gz (14.4 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page