postgres container w/ benefits
postgresql + docker + backblaze b2
this is a customized postgresql docker image
it extends from the official postgres docker image but adds some benefits
it automatically
- sets up another db + user
- activates extensions
- dumps, encrypts and uploads backups
BRANCH=$(git rev-parse --abbrev-ref HEAD)
docker build --rm -t napstr/poggres:$BRANCH .
docker push napstr/poggres:$BRANCH
on top of the existing env vars the following ones are available:
ROLE unpriviledged user / role
PASSWORD password for the role
DB database belonging to the role
EXTENSIONS any additional extensions delimited by spaces
BACKUP_DB database to backup
BACKUP_APPNAME name of the application to backup (meta information)
BACKUP_PASS password to encrypt the backup
BACKUP_BUCKET_DAILY b2 bucket for daily backups
BACKUP_BUCKET_WEEKLY b2 bucket for weekly backups
BACKUP_BUCKET_MONTHLY b2 bucket for monthly backups
BACKUP_ACCOUNT_ID b2 account id
BACKUP_APP_KEY b2 app key
simple
services:
dev-postgres:
image: napstr/poggres:16
restart: always
ports:
- 127.0.0.1:5442:5432
environment:
- POSTGRES_HOST_AUTH_METHOD=trust
- DB=foo
- ROLE=bar
- EXTENSIONS=hstoremore stuff
services:
db:
image: napstr/poggres:16
restart: always
ports:
- 127.0.0.1:5432:5432
volumes:
- ./postgres-data/16/data:/var/lib/postgresql/data
environment:
- POSTGRES_PASSWORD=top_secret
- DB=foo
- ROLE=bar
- PASSWORD=baz
- EXTENSIONS=hstore lo pg_trgm
- BACKUP_DB=foo
- BACKUP_APPNAME=next-big-thing
- BACKUP_PASS=top_secret
- BACKUP_BUCKET_DAILY=next-big-thing-backups-daily
- BACKUP_BUCKET_WEEKLY=next-big-thing-backups-weekly
- BACKUP_BUCKET_MONTHLY=next-big-thing-backups-monthly
- BACKUP_ACCOUNT_ID=xyy
- BACKUP_APP_KEY=yzz