C#•2mo ago

✅ How come my containerized postgres+pgadmin won't let me connect to db from pgadmin?

Hi there, I've made a small docker compose file that should start up a simple db with pgadmin. But I am unable to connect from pgadmin, here's the file:

version: '3.8'

networks:
  db-network:
    driver: bridge

services:
  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_DB: DevelopmentDB
      POSTGRES_USER: DevelopmentUser
      POSTGRES_PASSWORD: DevelopmentPassword
    volumes:
      - postgres-db:/var/lib/postgresql/data
    ports:
      - "5432:5432"
    networks:
      - db-network
  
  pgadmin:
    image: dpage/pgadmin4:latest
    environment:
      PGADMIN_DEFAULT_EMAIL: [email protected]
      PGADMIN_DEFAULT_PASSWORD: DevelopmentPassword
    volumes:
      - pgadmin-data:/var/lib/pgadmin
    depends_on:
      - db
    ports:
      - "5050:80"
    networks:
      - db-network

volumes:
  postgres-db:
  pgadmin-data:

version: '3.8'

networks:
  db-network:
    driver: bridge

services:
  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_DB: DevelopmentDB
      POSTGRES_USER: DevelopmentUser
      POSTGRES_PASSWORD: DevelopmentPassword
    volumes:
      - postgres-db:/var/lib/postgresql/data
    ports:
      - "5432:5432"
    networks:
      - db-network
  
  pgadmin:
    image: dpage/pgadmin4:latest
    environment:
      PGADMIN_DEFAULT_EMAIL: [email protected]
      PGADMIN_DEFAULT_PASSWORD: DevelopmentPassword
    volumes:
      - pgadmin-data:/var/lib/pgadmin
    depends_on:
      - db
    ports:
      - "5050:80"
    networks:
      - db-network

volumes:
  postgres-db:
  pgadmin-data:

So in pgadmin I try connecting like the atttached snippet. Any ideas where I go wrong?

9 Replies

cap5lut•2mo ago

localhost is wrong, the containers see each other via their container name as hostname, so in this case it should be db for the host address in pgadmin