A simple CLI utility for backing up PostgreSQL databases.
Project description
backupdb
An open-source CLI tool for backing up PostgreSQL database Locally or to Amazon S3 bucket
Usage
You will pass in the following on the command line:
- The CLI command
backup
- The
database URL
you need to connect to - The
storage driver (S3 or Local)
- The
destination (S3 bucket or local path)
Installation
$ pip install backupdb
Syntax
$ backupdb postgres://[USERNAME]:[PASSWORD]@[SERVER_IP:80/<db_name> --driver <driver_type> <destination>
Example usage for S3 backup
$ backupdb postgres://[USERNAME]:[PASSWORD]@[SERVER_IP:80/<db_name> --driver s3 mybucket01
Example usage for Local backup
$ backupdb postgres://[USERNAME]:[PASSWORD]@[SERVER_IP:80/<db_name> --driver local /var/local/mybackup.sql
Installation From Source
To install the package after you've cloned the repository, you'll want to run the following command from within the project directory:
$ pip install --user -e .
Preparing for Development
Follow these steps to start developing with this project:
- Ensure
pip
andpipenv
are installed - Clone repository:
git clone git@github.com:sharhan-alhassan/backupdb
cd
into the repository- Activate virtualenv
source /venv/bin/activate
- Install dependencies:
pip install -e .
orpip install -r requirements
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
backupdb-0.0.5.tar.gz
(4.5 kB
view hashes)