CLI for backup of remote PostgreSQL database either locally or to S3.
- Ensure
pipandpipenvare installed. - Clone repository:
git clone https://github.com/neildavies44/pgbackup.git cdinto the repository.- 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:
$ pgackup 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, then use:
$ pipenv run make