CLI for backing up remote PostgreSQL dbs
- Ensure using
pip
andpipenv
are installed. - Clone repo
git clone [email protected]:qovert/pgbackup
cd
into the repo dir.- Fetch development dependencies
make install
- Activate virtualenv:
pipenv shell
Pass in a full database URL, the storage driver, and the destination.
S3 Example w/bucket name:
- ::
- $ pgbackup postgres://[email protected]:5432/db_one --driver s3 backups
Local Example w/local path:
$ pgbackup postgres://[email protected]:5432/db_one --driver local /var/local/db_one/backups/dump.sql
Run tests locally using make
if virtualenv is active:
$ make
If virtualenv isn't active use:
$ pipenv run make