Skip to content

Latest commit

 

History

History
55 lines (43 loc) · 3.31 KB

README.md

File metadata and controls

55 lines (43 loc) · 3.31 KB
Raw

Backup Postgres Docker containers to Google Cloud Storage

Inspired by postgres-backup-s3

This docker image allows for scheduled backups of a postgres docker container to a Google Cloud Storage bucket.

Usage

This image is published on the docker hub.

Environment variables

Variable Description
POSTGRES_DATABASE The name of the database to backup.
POSTGRES_HOST The host of the database to backup.
POSTGRES_PORT The port of the database to backup. Default: 5432
POSTGRES_USER The username of the backup user.
POSTGRES_PASSWORD The password of the backup user.
POSTGRES_EXTRA_OPTS Any additional options you wish to pass to pg_dump. Default: ''
GCLOUD_KEYFILE_BASE64 The GCP service account's credential file, in base64. See below for recommendations regarding this.
GCLOUD_PROJECT_ID The Project ID which the bucket you wish to backup to is in.
GCS_BACKUP_BUCKET The gs:// path to the storage bucket you wish to backup to.
SCHEDULE How often you wish the backup to occur. See Scheduling for more information on formatting this.

Scheduling

More information on the schedule format can be found here.

Google Cloud Service Account

We recommend creating a new, write-only service account to the storage bucket you wish to backup to (with the storage.objects.list and storage.objects.create permissions).

Docker Compose

Below is a sample Docker Compose service.

dbbackups:
    image: "nullriver/postgres-docker-gcs-backup:latest"
    depends_on:
      - database
    networks:
      - internet
      - api-internal
    environment:
      SCHEDULE: "@every 6h"
      POSTGRES_HOST: "database"
      POSTGRES_DATABASE: "SomeDatabase"
      POSTGRES_USER: "postgres"
      POSTGRES_PASSWORD: "postgres"
      GCLOUD_KEYFILE_BASE64: "BASE64_PROJECT_KEYFILE_HERE"
      GCLOUD_PROJECT_ID: "hello-world"
      GCS_BACKUP_BUCKET: "gs://my-backup-bucket-name"

Note: the internet network exists as api-internal is an internal network with no connection to the internet. To enable backing up to the cloud, the service has to be on an external network which can access the internet. api-internal is the network which the database is on, so that the database hostname resolves to that service.