/pg_dump

Postgres Dump tool for S3 or Local

Primary LanguagePython

pgbackup =======

CLI for backing up remote PostgreSQL database either locally or to S3.

Preparing the Development

  1. Ensure pip and pipenv are installed.
  2. Clone repository: git clone git@github.com:youruser/pg_dump.git
  3. cd into the repository.
  4. Activate virtualenv: pipenv shell

Usage

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

S3 Example w/ bucket name:

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

Local Example with 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