s1s5/pgbackup repository overview

⁠backup postgres -> s3

set environment

- name: DATABASE_URL
  value: psql://user:[email protected]:8458/db
- name: BACKUP_ENCRYPT_KEY
  value: some-key-this-is-not-required
- name: S3_BUCKET_NAME
  value: backup-bucket
- name: S3_PATH
  value: path/to/backup

• backup to s3://${S3_BUCKET_NAME}/${S3_PATH}/<year>-<month>/<datetime>.sql.gz

⁠decrypt backup

• echo -n ${BACKUP_ENCRYPT_KEY} | gpg --batch --yes --no-tty -o dst.sql.gz --passphrase-fd 0 -d src.sql.gz.gpg