damoti/backup
Docker container for backing up PostgreSQL 10.0 databases.
Image
0
401
damoti/backup repository overview
backup
Docker container for backing up PostgreSQL 10.0 databases.
Hourly, daily, weekly, monthly and yearly backups are kept in separate directories and each have customizable rotation schedules.
Uses go-cron for scheduling backups.
docker-compose.yml Example
version: "3"
services:
pgdb:
image: postgres:10
backup:
image: damoti/backup
environment:
POSTGRES_HOST: pgdb
POSTGRES_DB: db1, db2
POSTGRES_PORT: 5432
POSTGRES_USER: postgres
POSTGRES_EXTRA_OPTS: '-Z9'
SCHEDULE: '@hourly'
BACKUP_DIR: '/backups'
BACKUP_KEEP_HOURLY: 14
BACKUP_KEEP_DAILY: 60
BACKUP_KEEP_WEEKLY: 52
BACKUP_KEEP_MONTHLY: 24
BACKUP_DAILY_HOUR_INTERVAL: 4
volumes:
- /var/lib/postgresql/backups:/backups
Environment Variables
| Variable | Default | Description |
|---|---|---|
| POSTGRES_DB | required One or more database names separated by space or comma, at least one is required. Backups will be performed for each database provided. | |
| POSTGRES_HOST | required Hostname passed to pg_dump command with -h. | |
| POSTGRES_PORT | 5432 | Port number passed to pg_dump command with -p. |
| POSTGRES_USER | postgres | User name passed to pg_dump command with -U. |
| POSTGRES_EXTRA_OPTS | -Z9 | Any extra options you want passed to pg_dump. |
| SCHEDULE | @hourly | When to run the cron job, see go cron docs for other options. |
| BACKUP_DIR | /backups | Path where host backup directory is mounted into the container. This is where the backup script will create hourly/daily/weekly/yearly directories and place the dump files inside the container. |
| BACKUP_KEEP_HOURLY | 14 | Number of days worth of hourly backups to keep (to get hourly backups make sure you have SCHEDULE set to @hourly or something more frequent). |
| BACKUP_KEEP_DAILY | 60 | Number of days worth of daily backups to keep. The number of actual backups per day that are kept is determined by BACKUP_DAILY_HOUR_INTERVAL. The default value gives you about 2 months worth of daily backups. |
| BACKUP_DAILY_HOUR_INTERVAL | 4 | Hours apart that daily backups should be made. Default value will produce 6 total backups per day, 4 hours apart. A value of 12 will give you 2 backups per day, a value of 24 will give 1 backup per day. |
| BACKUP_KEEP_WEEKLY | 52 | Number of weeks worth of weekly backups to keep. Due to how the backup script works this will be the last hour of a particular week. The default value gives you a year worth of weekly backups. |
| BACKUP_KEEP_MONTHLY | 24 | Number of months worth of monthly backups to keep. Due to how the backup script works this will be the last hour of the last day of a particular month. The default value gives you two years worth of monthly backups. |
Tag summary
Content type
Image
Digest
Size
115.5 MB
Last updated
about 9 years ago
docker pull damoti/backup