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 repository: git clone git@github.com/ahsec/pgbackup
3. cd into repository
4. Fetch development dependencies make install
5. Activate virtualenv: pipenv shell

Usage

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

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

Running tests

Run tests locally using make if virtualenv is active:

::

$make

If virtualenv isn't active then use:

::

$pipenv run make