Automated database backup

Table of Contents

• Table of Contents
• Important Data Locations
• PostgreSQL Backup via pgbackup Docker Container
  • Important Notes
  • docker-compose.yml

Important Data Locations

• PostgreSQL Database

PostgreSQL Backup via pgbackup Docker Container

The following example uses a docker container to dump the CRCON PostgreSQL database to a folder, which can then be backed up manually or via a server backup or snapshot from your server provider.

Important Notes

• You can create a new docker container for this function or you can add it to your CRCON docker-compose.yml
• Ensure that this service definition includes the network "common" so that it can connect to the postgresql docker container.

docker-compose.yml

pgbackups:
    image: prodrigestivill/postgres-backup-local
    restart: always
    # user: postgres:postgres # Optional: see below
    volumes:
      - ./pgbackups:/backups
    networks:
      - common
    links:
      - postgres
    depends_on:
      - postgres
    environment:
      - POSTGRES_PASSWORD=${HLL_DB_PASSWORD}
      - POSTGRES_USER=${HLL_DB_USER}
      - POSTGRES_DB=${HLL_DB_NAME}
      - HLL_DB_HOST=${HLL_DB_HOST}
      - POSTGRES_EXTRA_OPTS=-Z6 --schema=public --blobs
      - SCHEDULE=@daily
      - BACKUP_KEEP_DAYS=7
      - BACKUP_KEEP_WEEKS=4
      - BACKUP_KEEP_MONTHS=6
      - HEALTHCHECK_PORT=8080