docker-compose.yml

version: '3.9'

secrets:
  pgpass:
    file: ./pgpass

services:

  postgres:
    image: lovelysystems/docker-postgres:dev
    ports:
      - "5432:5432"
    environment:
      POSTGRES_PASSWORD: postgres
    volumes:
      # bind mount the data volume
      - "./volumes/postgres/data:/var/lib/postgresql/data"

      # map the bootstrap file into the init folder
      # this will be evaluated in the created database upon first startup
      - "./bootstrap.sql:/docker-entrypoint-initdb.d/bootstrap.sql:ro"

    # configure shared library preload for the debugger extension
    command:
      - '-c'
      - 'shared_preload_libraries=plugin_debugger'

  # pgadmin listening on http://localhost:1080
  pgadmin:
    image: dpage/pgadmin4:6.3
    depends_on:
      - postgres
    secrets:
      # the pass file to use with the pre configured server
      - source: pgpass
        mode: 600
        target: /var/lib/pgadmin/storage/admin/pgpass
    environment:
      PGADMIN_DEFAULT_EMAIL: admin@example.com
      PGADMIN_DEFAULT_PASSWORD: admin
    volumes:
      # local storage for pgadmin
      - ./volumes/pgadmin/data:/var/lib/pgadmin
      # the server definition file, only read on first start
      - ./servers.json:/pgadmin4/servers.json:ro
    ports:
      - "1080:80"

  client:
    image: lovelysystems/docker-postgres:dev-client
    profiles:
      - manual
    environment:
      PGHOST: postgres
      PGUSER: postgres
      PGPASSWORD: postgres