annixa/pg_dump

Docker image with pg_dump running as a cron task. Find the image, here: https://hub.docker.com/r/annixa/docker-pg_dump/

Usage

Attach a target postgres container to this container and mount a volume to container's /dump folder. Backups will appear in this volume. Optionally set up cron job schedule (default is 0 1 * * * - runs every day at 1:00 am).

Environment Variables:

Variable	Required?	Default	Description
`PGUSER`	Required	postgres	The user for accessing the database
`PGPASSWORD`	Optional	`None`	The password for accessing the database
`PGDB`	Optional	postgres	The name of the database
`PGHOST`	Optional	db	The hostname of the database
`PGPORT`	Optional	`5432`	The port for the database
`PGTABLE`	Optional	`*`	Select table to dump
`PGTABLE_SCRIPT`	Optional		Script to list tables to dump
`CRON_SCHEDULE`	Required	0 1 * * *	The cron schedule at which to run the pg_dump
`DELETE_OLDER_THAN`	Optional	`None`	Optionally, delete files older than `DELETE_OLDER_THAN` minutes. Do not include `+` or `-`.

Example:

postgres-backup:
  image: annixa/docker-pg_dump
  container_name: postgres-backup
  links:
    - postgres:db #Maps postgres as "db"
  environment:
    - PGUSER=postgres
    - PGPASSWORD=SumPassw0rdHere
    - CRON_SCHEDULE=* * * * * #Every minute
    - DELETE_OLDER_THAN=1 #Optionally delete files older than $DELETE_OLDER_THAN minutes.
  #  - PGDB=postgres # The name of the database to dump
  #  - PGHOST=db # The hostname of the PostgreSQL database to dump
  volumes:
    - /dump
  command: dump-cron

Run backup once without cron job, use "mybackup" as backup file prefix, shell will ask for password:

docker run -ti --rm \
    -v /path/to/target/folder:/dump \   # where to put db dumps
    -e PREFIX=mybackup \
    --link my-postgres-container:db \   # linked container with running mongo
    annixa/docker-pg_dump dump

Building

Building for multiple versions and architectures:

Building for amd64 and arm64, PostgreSQL 13

docker buildx build --platform linux/amd64,linux/arm64 --build-arg VERSION=13 "." --tag jungsoft/jungsoft/docker-pg_dump:13 --push

Building for amd64 and arm64, PostgreSQL 14

docker buildx build --platform linux/amd64,linux/arm64 --build-arg VERSION=14 "." --tag jungsoft/jungsoft/docker-pg_dump:14 --push