backup-postgres

A simple Docker container to create and encrypted backup of PostgreSQL to S3.

Backup PostgreSQL

docker run --rm \
-v ~/.aws:/aws \
--link postgres:postgres \
-e BUCKET=s3://bucket.example.com \
-e ENC_KEY=encryption_string \
-e PGHOST=postgres \
-e PGUSER=user \
-e PGPASSWORD=passwd \
hyperboloide/backup-postgres \
backup

Restore PostgreSQL

docker run \
--rm -ti \
-v ~/.aws:/aws \
--link postgres-restore:postgres \
-e BUCKET=s3://bucket.example.com \
-e ENC_KEY=encryption_string \
-e PGHOST=postgres \
-e PGUSER=user \
-e PGPASSWORD=passwd \
hyperboloide/backup-postgres \
restore