Skip to main content

A cli to perform a backup of postgres db on heroku and store to s3

Project description

# pybackups-py

A python port of [pgbackups-archive](
that helps in automating Heroku PGBackups and archiving them to Amazon S3.

# Overview

This package provides a python script `pgbackup` that will capture a Heroku
PGBackup, wait for it to complete, and then store it within the Amazon S3 bucket
you specify. Best way to use this package is to use heroku scheduler to schedule
this python script at any required durations and get automated offsite backups.
This project though can also be used as a library and can be used within
your own code. The `pgbackup` script can also be run
from command line to generate adhoc backups

This package doesn't interfere with or utilze automated backups, so feel free to
schedule those with the `pg:backups schedule` command as you desire.

# Installation

pip install -e pgbackups-py

# Usage

To use it with heroku scheduler:

#### Install Heroku Scheduler add-on

heroku addons:create scheduler

Setup an AWS IAM user, S3 bucket and policy
A good security measure would be to use a dedicated set of AWS credentials with
a security policy only allowing access to the bucket you're specifying. See this
Pro Tip on Assigning an AWS IAM user access to a single S3 bucket.

#### Configure Backups

The backups can either be configured by setting environment variables or by
passing arguments to the provided `pgbackup` script. On heroku environemnt
variables can be set as below

# Required
heroku config:add HEROKU_API_KEY="collaborator-api-key"
heroku config:add PGBACKUPS_APP="myapp"
heroku config:add PGBACKUPS_BUCKET="myapp-backups"

# Optional: If you wish to backup a database other than the one that
# DATABASE_URL points to, set this to the name of the variable for that
# database (useful for follower databases).

The `pgbackup` script takes following options

-h, --help show this help message and exit
--app APP Heroku App for which backup needs to be performed
--api-key API_KEY API key for heroku
--db DB_NAME Name of Heroku database
--access-key ACCESS_KEY
AWS Access Key
--secret-key SECRET_KEY
--aws-bucket AWS_BUCKET
AWS S3 Bucket
Log Level
--disable-logging Enable Logging
--log-name LOG_NAME Log Name
set additional storage options as key=value
--delete-after Delete backups from heroku after storing to s3

####Add the backup task to scheduler

heroku addons:open scheduler

Then specify `pgbackup` as a command you would like to run at any of the available intervals.

## License

* MIT license.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for pgbackups-py, version 0.0.1
Filename, size File type Python version Upload date Hashes
Filename, size pgbackups-py-0.0.1.tar.gz (7.1 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page