CLI for backing up remote PostgreSQL databases locally or to AWS S3
- Endsure
pipandpipenvare installed
sudo -H pip install -U pipenv pip install --user pipenv mkdir -p pgbackup cd pgbackup pipenv install --two pipenv shell(enable virt env)
- Clone repository: TODO provide github link
- Create README.rst
- Fetch developement dependencies:
make install
Pass in a full database URL, the storage driver, and destination
S3 example with bucket name:
$ pgbackup postgres://bob@examole.com:5432/db_one --driver s3 backups/dump.sql
Run tests locally using make if virtualenv is active:
- ::
- $ make
If virtualenv isn't active then use:
- ::
- $ pipenv run make