docker/swarm/stack/postgresql.yml

parameters:
  _param:
    docker_postgresql_replicas: 1
    docker_image_postgresql: library/postgres:9.6
    postgresql_admin_user: postgres
    postgresql_admin_user_password: postgrespassword
  docker:
    client:
      stack:
        postgresql:
          environment:
            POSTGRES_USER: ${_param:postgresql_admin_user}
            POSTGRES_PASSWORD: ${_param:postgresql_admin_user_password}
            SQLALCHEMY_POOL_RECYCLE: 14400
          service:
            db:
              image: ${_param:docker_image_postgresql}
              deploy:
                replicas: ${_param:docker_postgresql_replicas}
                restart_policy:
                  condition: any
              ports:
                - ${_param:haproxy_postgresql_exposed_port}:${_param:haproxy_postgresql_bind_port}
              volumes:
                - /srv/volumes/postgresql/data:/var/lib/postgresql/data