CLI for backup remote PostgreSQL database either locally or to S3
- Ensure
pig
andpipenv
are installed - Clone repository:
git clone [email protected]:example/pgbackup
cd
into the repository- Fetch development dependencies
make instal
- Activate virtualenv:
pipenv shell
Pass in a full database URL, the storage driver, and the destination
S3 Example w/ bucket name:
$ pgbackup pastgres://[email protected]:5432/db_one --driver s3 backups
Local Example w/ local path:
$ pgbackup pastgres://[email protected]:5432/db_one --driver local /var/local/db_one/backups/dump.sql
Run test locally using make
if virtualenv is active
- ::
- $ make
if virtualenv isn't active then use:
- ::
- $ pipenv run make