Skip to content

Latest commit

 

History

History
55 lines (34 loc) · 1.92 KB

README.md

File metadata and controls

55 lines (34 loc) · 1.92 KB

imixs/postgres

The imixs/postgres Docker image runs a backup service for Postgres Databases using the official postgres image.

The image runs version Postgres 12.2 and provides an backup and restore scripts. The backup feature can be configured in the same way as the imixs/backup image. See details here. The image does not start a postgres database. The goal of the image is providing a backup/restore service for postgres services.

Features

  • inherit form official postgres image
  • backup script to backup a database locally
  • restore script to restore from a local backup
  • remote backup script to create a remote rolling backup on a ftp space
  • remote restore script to restore a remote backup from a ftp space

1. Install Docker

Follow the Docker installation instructions for your host system.

2. Running and stopping a container

You can start an instance of the postgres service with the Docker run command:

docker run --name="postgres" -it --rm \
    -e SETUP_CRON="* 5 * * *" \
    -e BACKUP_DB_PASSWORD="xxxxxxxxxxx" \
    -e BACKUP_DB_HOST="db" \
    -e BACKUP_DB_TYPE="POSTGRES" \
    -e BACKUP_DB="wordpress" \
    imixs/postgres

Contribute

The source is available on Github. Please report any issues.

Development

To build the image from the Dockerfile source file run:

docker build --tag=imixs/postgres .

To test the backup service in interactive mode start the docker service:

docker run --name="postgres" -it --rm \
    -e SETUP_CRON="*/1 * * * *" \
    -e BACKUP_DB_PASSWORD="xxxxxxxxxxx" \
    -e BACKUP_DB_HOST="db" \
    -e BACKUP_DB_TYPE="POSTGRES" \
    -e BACKUP_DB="wordpress" \
    imixs/postgres

This will trigger the backup every minute.