Extended PostgreSQL Docker Image#

Docker image for postgres extended with management bash scripts.

Build images#

To build the images and push them to the registry:

make build
make push

Docker-compose example#

Example of a docker-compose.yml file that uses this image:

    version: '3'

    volumes:
      postgres_data: {}
      postgres_backups: {}

    services:

      service:
        image: service:latest
        command: ./start

      postgres:
        image: marcosgabarda/postgres:latest
        volumes:
          - postgres_data:/var/lib/postgresql/data
          - postgres_backups:/backups
        env_file:
          - ./.env

Maintenance commands#

This images adds commands to the original PostgreSQL image for maintenance proposes.

Create a database backup#

Creates a backup of the database. Usage:

$ docker compose -f <environment>.yml (exec |run --rm) postgres backup

View backups#

Views a list of all created backups of the database. Usage:

$ docker compose -f <environment>.yml (exec |run --rm) postgres backups

Creates a read only user#

Creates a read only user. Usage:

$ docker compose -f <environment>.yml (exec |run --rm) postgres createreaduser

Restore database from a backup#

Restores the indicated database backup. Usage:

$ docker compose -f <environment>.yml (exec |run --rm) postgres restore <1>

Parameters:

• <1> filename of an existing backup.