Docker Compose for PostgreSQL

docker_compose_for_postgresql.yaml

version: '3.5'

networks:
  sunnsaas:
    external: false
    name: network_name
    attachable: true

volumes:
  phd-data-postgis:
    external: false
    name: phd-data-postgis
    
configs:
  config_a:
    file: ./conf/config_a.json

services:
  postgis:
    image: malkab/postgis:holistic_hornet
    container_name: sunnsaas_postgis_v1

    # Put here other configs as described at the Docker image documentation
    environment:
      - PASSWORD=postgres

    networks:
      - sunnsaas

    ports:
      - "${MLKC_SUNNSAAS_DB_OUTER_PORT}:5432"

    # This tmpfs volume is a workaround to increase the shared memory allowed to be 
    # used by the container in a SWARM deployment. PG uses this in demanding queries.
    # This example increases the default to aprox. 8GB.
    tmpfs:
      - /tmp:size=8000000000

    volumes:
      - ./000_localhost_volumes/sunnsaas_postgis:/data
      - ../../assets/pg/postgresql.conf:/default_confs/postgresql.conf
      - phd-data-postgis:/whatever
      - type: tmpfs
        target: /dev/shm
    
    configs:
      - source: config_a
        target: /path/to/mount/config
        mode: 644