docker-compose.yml

services:
    # See https://hub.docker.com/_/postgres/ for details of the postgres image.
    # POSTGRES_PASSWORD - superuser password for PostgreSQL
    # POSTGRES_USER - superuser (default is 'postgres')
    # POSTGRES_DB - name of default database (default is value of POSTGRES_USER)
    db:
        image: postgres:14.11-alpine3.19
        volumes:
          - ./application:/data
        ports:
            - "5432"
        environment:
            POSTGRES_PASSWORD: r00tp@ss!

    # DB_HOST - hostname of the database server
    # DB_ROOTUSER - administrative user for the database server
    # DB_ROOTPASSWORD - password for the DB_ROOTUSER
    # DB_USER - user that accesses the database
    # DB_USERPASSWORD - password for the DB_USER
    # DB_NAME - name of database to back up/restore
    restore:
        build: ./
        volumes:
          - ./application:/data
        env_file:
            - ./local.env
        environment:
            DB_HOST: db
            DB_ROOTUSER: postgres
            DB_ROOTPASSWORD: r00tp@ss!
            DB_USER: dbuser
            DB_USERPASSWORD: dbuserpass
            DB_NAME: world
            MODE: restore
            CRON_SCHEDULE: "25 * * * *"

    backup:
        build: ./
        volumes:
          - ./application:/data
        env_file:
            - ./local.env
        environment:
            DB_HOST: db
            DB_ROOTUSER: postgres
            DB_ROOTPASSWORD: r00tp@ss!
            DB_USER: dbuser
            DB_USERPASSWORD: dbuserpass
            DB_NAME: world
            MODE: backup
            CRON_SCHEDULE: "20 * * * *"