createdb.sh

docker exec ubuntu_postgres_1 createdb my_database -U postgres

docker-compose.yml

version: '3'

volumes:
  postgres-data:
    driver: local

services:
  postgres:
    image: postgres:10.10
    ports:
      - 5432:5432
    restart: always
    environment:
      POSTGRES_PASSWORD:
    volumes:
     - /home/ubuntu/ftp/postgres/dumps:/db/dumps
     - postgres-data:/var/lib/postgresql/data

dropdb.sh

docker exec ubuntu_postgres_1 dropdb -U postgres my_database

pg_restore.sh

docker exec ubuntu_postgres_1 pg_restore --verbose --clean --no-acl --no-owner -U postgres -d my_database /db/dumps/latest.dump

pg_restore_schema.sh

docker exec ubuntu_postgres_1 pg_restore --verbose --clean --no-acl --no-owner -U postgres -d my_database --schema=public /db/dumps/latest.dump

template.sh

docker exec ubuntu_postgres_1 createdb -T my_database new_my_database -U postgres