worek 0.1.0

Database Backup Command Line Utility

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

• Cleanup Piping Mechanism (da86b5b)

• Setup CI for PG9.6 and PG10 (002640b)

• Cleanup API and add tests (e5371da)

• Update Readme (0697703)

• Add init for packages (78e6ec2)

• Setup a Postgres Backup Tool (be27b46)