Skip to content

pgAdmin Example

About pgAdmin

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

More information about pgAdmin

How to add pgAdmin to Qlico?

Add the following YAML to the services section of your docker-compose.yaml file.

qlico-core/docker-compose.yaml
  pgadmin4:
    image: dpage/pgadmin4:latest
    container_name: qlico-core_pgadmin
    environment:
      PGADMIN_DEFAULT_EMAIL: ${PGADMIN_DEFAULT_EMAIL:-pgadmin4@pgadmin.qlico}
      PGADMIN_DEFAULT_PASSWORD: ${PGADMIN_DEFAULT_PASSWORD:-qlico}
    volumes:
      - pgadmin4-data:/root/.pgadmin
    labels:
      - "traefik.http.routers.pgadmin4.rule=Host(`pgadmin4.qlico`)"
      - "traefik.http.services.pgadmin4.loadbalancer.server.port=80"
    networks:
      - qlico-core

Add the following YAML to the volumes section of your docker-compose.yaml file.

qlico-core/docker-compose.yaml
  pgadmin4-data:
    name: qlico-core_pgadmin4-data

This is a large example, so you know where to place the pgAdmin service and volume.

qlico-core/docker-compose.yaml
---
# Author: Qlico <hello@qlico.dev>
services:
  traefik:
    image: traefik:v3.4.0
    container_name: qlico-core_traefik
    command: ["--providers.docker", "--api.insecure"]
    networks:
      - qlico-core
    ports:
      - 80:80
    volumes:
      - /var/run/docker.sock:/var/run/docker.sock
    labels:
      - "traefik.http.routers.traefik.rule=Host(`traefik.qlico`)"
      - "traefik.http.services.traefik.loadbalancer.server.port=8080"
  pgadmin4:
    image: dpage/pgadmin4:latest
    container_name: qlico-core_pgadmin
    environment:
      PGADMIN_DEFAULT_EMAIL: ${PGADMIN_DEFAULT_EMAIL:-pgadmin4@pgadmin.qlico}
      PGADMIN_DEFAULT_PASSWORD: ${PGADMIN_DEFAULT_PASSWORD:-qlico}
    volumes:
      - pgadmin4-data:/root/.pgadmin
    labels:
      - "traefik.http.routers.pgadmin4.rule=Host(`pgadmin4.qlico`)"
      - "traefik.http.services.pgadmin4.loadbalancer.server.port=80"
    networks:
      - qlico-core

volumes:
  pgadmin4-data:
    name: qlico-core_pgadmin4-data

networks:
  qlico-core:
    driver: bridge
    name: qlico-core