docker-compose.yml

version: '3'
services:
  db:
    image: postgres:11
    environment:
      - POSTGRES_USER=postgres
      - POSTGRES_PASSWORD=secret
    volumes:
      - database-data:/var/lib/postgresql/data/
      - .:/app
    ports:
      - '5432:5432'

volumes:
  database-data:

run.sh

$!/bin/sh

# start up database
docker compose up -d

# create target database
docker compose exec -T db psql -U postgres <<SQL
CREATE DATABASE postfacto;
SQL

# put the binary dump into created database
docker compose exec db pg_restore -Fc \
    -d postfacto \
    --verbose \
    --clean \
    --no-acl --no-owner \
    -U postgres \
    /app/541bd2d9-222d-4918-97c5-f8a5548890bf.pgdump

# get the binary dump out as plain SQL
docker compose exec db pg_dump \
    -d postfacto \
    --verbose \
    --clean \
    --no-acl --no-owner \
    -U postgres \
    | gzip -c > dump.sql.gz