icornett/Python_LinuxAcademy

Postgresql backup utility as part of LinuxAcademy Python coursework

pgbackup

CLI for backing up remote postgresql databases locally or to AWS S3.

Preparing for Development

1. Ensure pip, and pipenv are installed.
2. Clone the repository: git clone git@github.com:example/pgbackup
3. Fetch development dependencies: make install

Usage

Pass in a full database URL, the storage driver, and a destination.

S3 Example w/ bucket name:

$pgbackup postgres://bob@example.com:5432/db_one --driver s3 backups

Local Example w/ local path:

$ pgbackup postgres://bob@example.com:5432/db_one --driver local /var/local/db_one/backups/dump.sql

Running Tests

Run tests locally using make if virtualenv is active:

$ make

If virtualenv isn't active, then use:

$ pipenv run make